Map the bank ER schema given below into a relational schema. Do not forget to specify all primary and foreign keys.
A. Bank_Branches(BranchID PRIMARY KEY, BranchName, Location, BankID FOREIGN KEY)
B. Bank_Accounts(AccountID PRIMARY KEY, AccountType, Balance, BranchID FOREIGN KEY)
C. Customers(CustomerID PRIMARY KEY, CustomerName, Address, AccountID FOREIGN KEY)
D. Transactions(TransactionID PRIMARY KEY, TransactionType, Amount, AccountID FOREIGN KEY)
