Question: Please make it as clear as possible Consider the following set of requirement for a BANK database. Then draw an ER diagram based the requirement.
Please make it as clear as possible
Consider the following set of requirement for a BANK database. Then draw an ER diagram based the requirement.
The database keeps track of each backs name, routing number, address. Banks has bank branch (you could name the relationship as BRANCHES). The bank branch described as branch name, branch location and branch ID. The branch ID is unique for each bank, but not unique in general.
Users open account in bank branches. The accounts described by account number, account type, account password.
Users could own several account. One user should have at least one account.
Account could create transactions. The transaction described by transaction ID, amount and type of transactions.
You should draw entity types, attributes and relationships in the ER diagram
Specify key attributes of each entity type
Use double lined rectangular to represent weak entity types
Specify (min, max) on relationships
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
