Question: NORMALIZATION Consider the following relation: Repayment (borrower_id, name, address, loanamount, requestdate, repayment_date, repayment_amount) The following is noted: A borrower is identified with an unique

NORMALIZATION Consider the following relation: Repayment (borrower_id, name, address, loanamount, requestdate, repayment_date, repayment_amount) The following is noted: A borrower is identified with an unique borrower_id, and has only one address. Borrowers can have multiple simultaneous loans, but they always have different request dates. The borrower can make multiple repayments on the same day, but not more than one repayment per loan per day. a) State a key (candidate key) for Repayment. [1 mark] b) Describe different types of anomalies that can arise for this table with example records of how they can occur in this table. [6 marks] c) Describe and illustrate the process of normalization by creating the normalized tables that are normalized up to 4NF. Ensure to identify the primary keys and foreign keys in each derivation. [5 marks] A BI
Step by Step Solution
There are 3 Steps involved in it
a A key candidate key for the Repayment relation could be borrowerid and requestdate This combination uniquely identifies each tuple in the relation s... View full answer
Get step-by-step solutions from verified subject matter experts
