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:


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.


Submit on paper to the School office by 25 April at 15:00.