Question

2. Design an ER-diagram for a bank that implements the following requirements. The database you design should store information about customers, accounts, branches and employees

• Customer: Customers are identified by their SSN. For each customer we store a name, multiple phone numbers (one or more), and an occupation.

• Account: Accounts are identified by an account number and the branch they belong to. For each account we store a balance and the type of account (e.g., savings).

– An account belongs to one or more customers. A customer can have any number of accounts.

– An account belongs to exactly one branch. Obviously, branches can have multiple accounts (branches are not required to have accounts).

• Branch: A branch is identified by a unique branch code. For each branch we want to store a location and number of employees.

• Employee: Employees are identified by their SSN. For each employee we store a name and salary.

– An employee works for exactly one branch. Branches have one or more employees.

– An employee is the contact for zero or more customers. Every customer has at most one employee as a contact.                                                    [20 marks]

Answer 1

Above is the ER Diagram for a Bank Management system as per the requirements mentioned in the question.