Question 1
This question tests your knowledge and understanding of normal forms as presented in Unit 5 of Block 2.
Given the following relation and functional dependencies, answer questions (a) - (d), then answer question (e).
(a) Show 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), determine any alternate keys.
(b) Normalize the relation T up to 2NF relations only. Indicate the primary key of each relation.
(c) Further normalize the result of (b) above up to 3NF only. Indicate the primary key of each relation.
(d) Further normalize the result of (c) above up to BCNF only. Indicate the primary key of each relation.
(e) State two further problems that can occur in BCNF relations requiring further normalization beyond BCNF.