Consider the ER diagram shown in Figure $1$ for part of a BANK database. Each bank

can have multiple branches. Each branch can have multiple accounts and loans. Each

customer can have multiple accounts and loans.

Figure $1$: An ER diagram for a BANK database schema

$($a$)$ What issues does the above ER diagram have? How to revise the ER diagram to

address these issues?

$($b$)$ Map the Bank$\_$Branch weak entity type and the has$\_$L relationship type into

relation schemas. Specify all primary keys and foreign keys.

$($c$)$ Based on the ER diagram given in Figure $1,$ can a customer open multiple ac$-$

counts of the same type at the same bank branch? Justify your answer.