CHAPTER 4: DATABASE NORMALIZATION
INDIVIDUAL ASSIGNMENT 2
Learning Outcome:
CPS4 (5%) CPS1(5%)
Student Learning Time:
The estimated time to complete this task is 16 hours.
1. Create a set of normalized relations given the bill shown below.
2. Perform normalization until 4NF for the following information.
3. Perform normalization until 3NF for the following information.
4. The following relation schema can be used to register information on the repayments on micro loans.
Repayment (borrower_id, name, address, loanamount, requestdate, repayment_date, repayment_amount)
A borrower is identified with a 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.
b) Perform normalization to BCNF. Show the steps.
c) Is BCNF always the best option in database design? Discuss by giving examples.