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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!