Coursework 5
Consider a relation R(CustomerNumber, Name, Address, CardType, CardNumber).
CustomerNumber is a candidate key, and so is CardNumber (assume that each credit card has
exactly one named owner).
Functional dependencies:
- CustomerNumber determines Name, Address, CardType, CardNumber
- CardNumber determines CustomerNumber, Name, Address, CardType
Exercise
For each of 2NF, 3NF and BCNF, explain whether the relation above is in that
normal form. Normalise the relation to BCNF
(list new tables and column names for each table). Explain why the resulting tables
are in BCNF.
Submission
Submit on paper to the School office by 25 April at 15:00.