Question

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.2.1) (1 point) Give all likely FDs.
2.2) (1 point) Give the candidate keys for the ABC relation. Explain your answer.
2.3) (1 point) 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.

ABC(customerNo,customerName, phone, address, dateofBirth, EmailAddress, AccountNo, Balance, Type, RegisterBranchBSB, Branchaddress, ServicePhone,...
Get unstuck

372,107 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses