Do not copy from other answers and please do not use AI

Please do note that you need to have knowledge on

"Data Management and File Structures" to solve this

Consider the Bank database given below:

Branch $($branch$-$name, branch$-$city, assets$)$

Customer $($ID$,$ customer$-$name, customer$-$street, customer$-$city$)$

Loan $($loan$-$number, branch$-$name, amount$)$

Borrower $($ID$,$ loan$-$number$)$

Account $($account$-$number, branch$-$name, balance$)$

Depositor $($ID$,$ account$-$number$)$

a$)$ What are the appropriate primary keys and foreign keys?

b$)$ Construct a schema diagram for the bank database.