$5.$ Draw ER diagram for a banking database using the given details.

Step$1)$ Entity Identification and attributes

Customer $($CID$,$ Name, Address, City$)$

Account $($Account$\_$Number, Balance$)$

Savings$-$Account $($Interest Rate$)$

Checking$-$Account $($Overdraft Amount$)$

Loan $($LID$,$ Amount, Interest, Branch$)$

Employee $($EID$,$ Name, Hire$-$date, Contact, Manager$\_$Name, Designation$)$

Course

Name

Branch Subject Name with Code Semester Assignment

Unit No$.$

B$.$Tech CSE$/$EE ICS$402$ Data Base Management

System

$4$th $2$

Branch $($BID$,$ Name, City$)$

Payment $($PID$,$ Date, Amount$)$

Step$2)$ Relationship Identification

Customers can borrow a loan or deposit cash

Deposited cash will be logged into a register and will be connected to an account

Deposited cash goes into the Savings$-$Account

The customer may be an employee at the bank and may get some extra benefits

Loans can be given at different rates depending on the branch

Step $3)$ Cardinality Identification

A customer can have many accounts

A customer can have multiple loans

The loan will be provided by exactly $1$ branch