4NF – Fourth 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 Fourth Normal Form (4NF) address?
2. Which conditions must a table meet to be in Fourth Normal Form?
3. What is a multi-valued dependency?
4. What is the "Cartesian explosion" described in relation to Fourth Normal Form?
5. In the loan example, a loan has two collateral types and two guarantors stored in one table. How many rows does the table produce?
6. How is the loan collateral and guarantor problem resolved under Fourth Normal Form?
7. How does Fourth Normal Form differ in focus from the earlier normal forms?
8. In which kinds of domains is a failure to recognise multi-valued dependencies most likely to cause subtle data distortions?
9. Which of the following is NOT stated as something Fourth Normal Form provides?
10. Why do many real-world systems implicitly satisfy Fourth Normal Form?