5NF – Fifth 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. By what other name is Fifth Normal Form (5NF) known?
2. What kind of dependency does Fifth Normal Form address?
3. What is the formal condition for a table to be in Fifth Normal Form?
4. In the Fifth Normal Form loan example, into which three binary tables can LoanGuarantorCollateral (LoanID, GuarantorID, CollateralType) be decomposed?
5. When should a table be decomposed into its projections under Fifth Normal Form?
6. Which two conditions must a Fifth Normal Form decomposition satisfy?
7. What is the key difference between Fourth Normal Form and Fifth Normal Form?
8. In which kinds of domains does Fifth Normal Form become relevant?
9. What should be done if business rules constrain which loan guarantor and collateral combinations are allowed?
10. Conceptually, what kind of relationships does a table in Fifth Normal Form contain?