Consider the Customer account database of the ABC big bank,

Consider the Customer account database of the ABC big bank, which keeps data for customers and their orders. A database of only one relation is designed, as shown below:

ABC(customerNo,customerName, phone, address, dateofBirth, EmailAddress, AccountNo, Balance, Type,

RegisterBranchBSB, Branchaddress, ServicePhone, ServiceEmployeeNo, ServiceEmployeeName)

● A customer has a unique customer number (customerNo) and is also described by name, phone number, address, dateofBirith and EmailAddress.

● An account is identified by a unique account number (AccountNo).

● A Branch has a unique branch BSB(RegisterBranchBSB) and has an address (Branchaddress).

● A customer can open several accounts and an account is made by only one customer.

● A customer can own several bank account types, and a bank account type can belong to several customers

● A customer account has one service employee (ServiceEmplyeeNo) and one service employee can be responsible for several customer accounts.

Answer questions:

2.1) Give all likely FDs.

2.2) Give the candidate keys for the ABC relation. Explain your answer.

2.3) Give {CustomerNo}+ and {AccountNo, ServiceEmployeeNo}+ based on the FDs for Question 2.1).

2.4) (1 point) Is the relation ABC in BCNF or 3NF? Explain your answer.