Consider the Customer account database of the ABC big bank, which keeps data for customers and their
Question:
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.
Financial and Managerial Accounting
ISBN: 978-0132497978
3rd Edition
Authors: Horngren, Harrison, Oliver