Unit 2: Normalization
Functional Dependency & Normal Forms
15 min read · 60% complete
Explanation
Normalization organises tables so the same fact is not stored twice.
Each normal form removes one kind of redundancy.
Key exam points
- 2NF removes partial, 3NF removes transitive dependencies
- BCNF: LHS of every FD must be a superkey
- BCNF may not preserve dependencies
Previous year questions
Normalise the given relation up to BCNF showing each step.
2024 · 10 marks
Find the candidate keys of R(A,B,C,D) with the given FD set.
2023 · 6 marks
Practice quiz
Which normal form removes transitive dependency?