Question
This question tests your facts and understanding of normal forms.
Given following relation and functional dependencies, answer questions (a) to (d), then answer question (e).
(a) Illustrate that the relation T above is only in 1NF and does not conform to any higher normal forms. Given that the primary key is (A, B), decide any alternate keys.
(b) Standardize relation T up to 2NF relations only. Indicate the primary key of each relation.
(c) Further regularize result of (b) above up to 3NF only. Show the primary key of each relation.
(d) Further control the result of (c) above up to BCNF only. Show the primary key of each relation.
(e) Position two further problems that can occur in BCNF relations requiring further normalization beyond BCNF.