Q1) Lee Wong is the newly appointed database administrator at standard bank. The management of this bank wants to computerize the process of banking. According to the bank’s policy, one customer can have many accounts but one account cannot be shared by many customers. The following Er diagram represents the relationship between a customers and the accounts owned by a particular customer. In the preceding diagram, you have to identify entities, their attributes, and type of relationship between the entities.

The following list describes the entities, the attributes, and the relationship of the preceding ER diagram.

• ·         Entities – Customer and Account
• ·         Attributes of Customer – Customer Name, SSN Number, and Customer Address
• ·         Attributes of Account – Account Number and Balance
• ·         Type of Relationship – One to Many