Question:

A bank has many branches in a country. Each branch is identified with the help of branch name. Each branch of the bank has multiple customers. Customers also include employees of that particular branch. An employee can be a manager or staff of that branch. Branch gives each customer an id in order to identify them. Customers can open two types of accounts i.e. saving account and Checking account. Branches of the bank provides Loan to the customers if required.  Re-Payment of loan is done with the help of payment number of that particular loan.

Draw an extended ER diagram with the help of above details.

 

ImageImageImageImageImageImage

Advertisements