a.

A customer can have one or more accounts. Joint accounts are possible; that is, an account can be held by many customers. There is no limit on how many transactions that can be carried out for an account on any given day. A customer can have one or more phone numbers and email addresses as contact details. A phone number or an email address can be shared by multiple customers as well. A sample (and potentially incomplete and incorrect) relational database design for the bank to store the above data is given by the following. Customer(Customer Number, Customer Name, Customer Address, Customer Contact) Account(Account Number, Account Type) Transaction(Transaction Number, Transaction Type, Transaction Date, Transaction Amount) Assuming you want to implement the Customer table as given above, the primary key for Customer should be: O a. Customer Number b. Customer Number+Customer Name O c. Customer Number+Customer Contact O d. Customer Contact O e. None of the aboveAccount Balance is missing in the given design. It should be an attribute in the following table: a. Customer only b. Account only O c. Either Customer or Account O d. A table other than the given three O e. TransactionWhich of the tables in the given design is/are not in III NF. O a. Only Customer is not in III NF O b. Only Account is not in III NF O c. Only Transaction is not in III NF O d. All three tables are in III NF O e. None of the tables is in III NFSuppose I merge Account and Transaction tables into the following one table: AccnnntTransactinchonnnt Number. Account Type, Transaction Number, Transaction Type. Transaction Date Transaction Amount] The primary key for the merged table is .3 an. Account Nlunher only {i} h. Transaction Number only:r G c. Either Account Number or Transaction Number 0 d.Account Number T Transaction Number :3 e. There is. no primary Ire};r for the table In order to link accounts with customers, the given design should be changed in the following way: O a. Put Account Number in the Customer table Ob. Put Customer Number in the Account table c. Create a new table and put Account Number and Customer Number in that table O d. Do either A or B O e. None of the aboveThe database design should have the following constraint. O a. Account Balance should be positive O b. Transaction Amount should be non-negative c. Customer Number in Customer table should be non mull O d. A and C O e. B and CThe database design should have the following constraint. O a. Transaction Amount > Account Balance Ob. Transaction Amount