Question

Draw an ER diagram according to the following requirements.  

The bank application keeps track of the following information. As a customer of the bank, he/she must either own an account or borrow a loan. The banking application does not require a customer to both own account and borrow a loan. Customer information includes a SSN (unique), a name, and an address. A customer can borrow at most one loan. A loan has a loan number (unique) and an amount. A loan must be borrowed by at least one customer. An account has an account No (unique) and an amount. A customer may own many accounts. An account can be owned by many customers, at least one. The date that a customer starts to own an account also needs to be recorded.

Answer 1

Answer:

ER - Diagram

Address Account_no Amount Name SSN Account no SSN Customer Owns Owns Account Account OwnedDate Have Loan Loan_no Amount

Explanation:

Customer entity have three attribute SSN, Name, Address from which SSN is primary key.

Account has two attributes Account_no and Amount from which Account_no is the primary key.

Customer and Account related with Many to Many relationship with OwnedDate.

Loan entity has two attributes namely Loan_no and Amount from which Loan_no is primary key.