Examlex

Solved

Create an ER Diagram Based on the Following Requirements

question 93

Essay

Create an ER diagram based on the following requirements:
The database will keep track of students and campus organizations.
- For each student,we will keep track of his or her unique student ID,and his or her name and gender.
- For each organization,we will keep track of its unique organization ID and the location.
- Each student in the database belongs to at least one organization and can belong to multiple organizations.
- Each organization in the database has at least one student belonging to it and can have multiple
students.
- For every instance of a student belonging to an organization,we will record the student's function in the organization (e.g. ,president,vice president,treasurer,member,etc. ).


Definitions:

Account

A record or statement that keeps track of financial transactions or an arrangement with a bank to deposit, withdraw, or manage money.

Invoice

A document issued by a seller to a buyer that lists the products or services provided and specifies the amount owed for them.

Outstanding Balance

The amount of money owed that remains unpaid.

Payment

The act of transferring money or consideration from one party to another in exchange for goods, services, or to fulfill a legal obligation.

Related Questions