Deep Dive into Normalization Forms
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is the correct order of the full normalisation ladder?
2. Which of the following is NOT one of the consistent objectives of normalisation across the ladder?
3. What does First Normal Form (1NF) require?
4. What does Second Normal Form (2NF) remove?
5. What does Third Normal Form (3NF) eliminate?
6. What does Boyce-Codd Normal Form (BCNF) require?
7. Which normal form removes multi-valued dependencies?
8. What does Fifth Normal Form (5NF) ensure?
9. Which specialised approaches are influenced by higher normal forms such as 6NF?
10. In the loan approval case study for the normalisation ladder, what is the starting structure?