Create a ERD for a bank database system using the following requirements:

There are three entities: one for client $($or clients$),$one for account $($or accounts$)$ and one for loan $($or loans$).$

Clients are identified by their client number $($primary key$).$ Their first name, last name,

social security number, address $($Street$,$ City, Zip and State$),$ date of birth, age and phone.

number are of interest to the bank.

Clients can open multiple accounts: one account belongs to one client only, but one

client can open several accounts.

Each account has an account number $($primary key$)$ and a balance.

Clients can borrow money through loans by the following rules:

Several clients can own the same loan

One client can have several loans

Each loan has a loan number $($primary key$)$ and an amount of money

Not every client has to have a loan, but a loan should have at least one client who borrows it$.$

Identify all necessary attributes mentioned in the requirements above.

Underline primary keys.

Create necessary relationships between entities, and specify the cardinality $($one$-$to$-$one; one$-$to$-$many; many$-$to$-$many$)$ in each relation. You should place $"1","$M$",$ or $"$N$"$ on each relation line.