ASSIGNMENT TASKS:

$1.$ Consider a Bank Database:

Each Bank can have multiple branches, and each branch can have multiple accounts and loans.

A customer can have multiple accounts and loans. It is necessary to keep track of different types of CUSTOMER$($Customer ID$,$ Name, Address, Phone Number

ACCOUNTS$($Account Number, Account Type, Balance, Date Opened $)$ and

LOANS$($Loan Number, Loan Type, Loan Amount, $)$ Suppose it is desirable to keep track of each account's TRANSACTIONS $($Transaction ID$,$ Transaction Type, checks, Amount, Account Number $)$ and each loan'sPAYMENTS; both of these include the amount, date and time.

Create the ER diagram,

$-$ Show and Specify the relationships between each entity

$-$ Show the attributes of each entity underlining the primary key in each entity.

$-$ Identify and include any Foreign Keys present