3NF – Third Normal Form
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What kind of dependency does Third Normal Form (3NF) remove?
2. What is a transitive dependency?
3. In the dependency pattern A → B → C used to describe a transitive dependency, what does A represent?
4. In the loan approval example, which chain illustrates a transitive dependency in the Loan table?
5. Why do CustomerName and CustomerAddress not belong in the Loan table under Third Normal Form?
6. How does Third Normal Form resolve the customer-detail dependency in the Loan table?
7. What benefit follows from Third Normal Form when a customer's address changes?
8. Which of the following is NOT part of the rule for achieving Third Normal Form?
9. For which kind of system is Third Normal Form often considered sufficient?
10. Which normal form addresses the subtle integrity problems that Third Normal Form may still allow?