You are asked to design a database for Banks. A bank will have unique Code, Name and Address. All banks will have multiple branches and each of those branches will have a branch number for example the first branch of a particular bank will have branch number -1 and these will have an address of their own besides the branch number, also the opening date of each branches will be recorded. All 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 customer’s National_ID, Name, Phone and Address will be taken and stored. Note that a customer could exist in the bank database without having an account. Using these Requirements please construct an Entity-Relationship diagram.
You are asked to design a
Address. All banks will have multiple branches and each of those branches will have a branch
number for example the first branch of a particular bank will have branch number -1 and
these will have an address of their own besides the branch number, also the opening date of
each branches will be recorded. All 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 customer’s National_ID, Name, Phone and Address will be taken and stored. Note that a customer could exist in the
bank database without having an account. Using these Requirements please construct an
Entity-Relationship diagram.
Step by step
Solved in 2 steps with 1 images
