Accounts(customer (C), addr (A), account_id (AID), branch_id (BID), balance (B), manager_id (M)), where () is the abbreviation
Question:
Accounts(customer (C), addr (A), account_id (AID), branch_id (BID), balance (B), manager_id (M)), where () is the abbreviation of the field for convenience of discussion.
The above table stores the information that a customer has address (addr) and account (account_id) with the balance at the branch (branch_id) that has the manager (manager_id). Each customer has only one address and each branch has only one manager.
Describe to your supervisor what potential problems the above data representation may have.
Provide advice to the supervisor on how to restructure the data representation to avoid such problems through decomposing the table into smaller tables.
Since your supervisor may not know database theory such as FDs and normal forms, your answers to (a) and (b) should focus on the intuition behind and should be easily understandable to the supervisor.
Statistics For The Life Sciences
ISBN: 9780321989581
5th Edition
Authors: Myra Samuels, Jeffrey Witmer, Andrew Schaffner