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
An account is identified by a unique account number ('AccountNo').
A Branch has a unique branch BSB (
RegisterBranchBSB) and has an address (
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.
I just want to know what are the likely functional dependencies in this relation, such as partial,transitive, multi-valued, join dependencies.
The candidate keys in that relation