You are asked to design a database for Banks. A bank will have one unique Code, Name and Address. Banks will have multiple branches and each of those branches will be numbered (1,2..), first branch will be Number 1 for example and these will have an address of their own besides the branch number. The Bank Branches will offer the option of creating accounts to customers, they will also have the option of creating joint accounts. Customers will be able to open different accounts in each of the bank branches. Account information will include the unique Account Number, Total Balance and Account Type. The Bank Branches will also give Loans to Customers. Loans will have unique Loan Number, Loan Amount and Loan Type. A customer can take multiple loans from a certain bank branch and banks can issue a number of different types of loans just like accounts. The customer’s National_ID, Name, Phone and Address will be taken and stored. Using these Requirements please construct an Entity-Relationship diagram. [Note- Use the notations and symbols] Hint: Do not forget to add the different constraints in the ER diagram, use common sense where required, for example one account cannot belong to multiple banks.
A) You are asked to design a
Address. Banks will have multiple branches and each of those branches will be numbered (1,2..), first branch will be Number 1 for example and these will have an address of their own besides the
branch number. The Bank Branches will offer the option of creating accounts to customers, they will
also have the option of creating joint accounts. Customers will be able to open different accounts in
each of the bank branches. Account information will include the unique Account Number, Total
Balance and Account Type. The Bank Branches will also give Loans to Customers. Loans will have
unique Loan Number, Loan Amount and Loan Type. A customer can take multiple loans from a
certain bank branch and banks can issue a number of different types of loans just like accounts. The
customer’s National_ID, Name, Phone and Address will be taken and stored. Using these
Requirements please construct an Entity-Relationship diagram. [Note- Use the notations and
symbols]
Hint: Do not forget to add the different constraints in the ER diagram, use common sense where
required, for example one account cannot belong to multiple banks.
B) Construct a Relational Database Schema using the Entity Relationship Model Diagram that you
created in the previous questions
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 9 images
