6NF – Sixth 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 guiding idea summarises Sixth Normal Form (6NF)?
2. What is the condition for a table to be in Sixth Normal Form?
3. What temporal problem does Sixth Normal Form solve for a loan whose interest rate and status change independently?
4. In the Sixth Normal Form loan example, what columns does the LoanInterestRate table contain?
5. What typically makes up the primary key of a Sixth Normal Form table?
6. What is the difference between transaction-time and valid-time in bi-temporal modelling?
7. Which modelling techniques are named as embracing Sixth Normal Form style fine-grained decomposition?
8. Which of the following is NOT a benefit attributed to Sixth Normal Form?
9. For which scenarios is Sixth Normal Form said to be best suited?
10. How do many organisations apply Sixth Normal Form in practice?