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