Q4Database Management System
Question
10 marks
What is Normalization? Explain 2NF, 3NF and BCNF with suitable examples.
Answer
2NF: No partial FD; 3NF: No transitive FD; BCNF: Every determinant is a candidate key.
Detailed explanation of normal forms with examples.