ENTITY RELATIONSHIP DIAGRAM

ASSIGNMENT TASKS:

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