Consider the bank database given below.
a. What are the appropriate primary keys?
b. Given your choice of primary keys, identify appropriate foreign keys.
branch(branch name, branch city, assets)
customer (customer name, customer street, customer city)
loan (loan number, branch name, amount)
borrower (customer name, loan number)
account (account number, branch name, balance)
depositor (customer name, account number)