NORMALIZATION Consider the following relation: Repayment (borrower_id, name, address, loanamount, requestdate, repayment_date, repayment_amount) The following is...

 

Transcribed Image Text:

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 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