6NF – Sixth Normal Form

Share this topic

6NF – Sixth Normal Form

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Self-check

Questions 1–10 of 10

  1. 1. What guiding idea summarises Sixth Normal Form (6NF)?

    Question 1
  2. 2. What is the condition for a table to be in Sixth Normal Form?

    Question 2
  3. 3. What temporal problem does Sixth Normal Form solve for a loan whose interest rate and status change independently?

    Question 3
  4. 4. In the Sixth Normal Form loan example, what columns does the LoanInterestRate table contain?

    Question 4
  5. 5. What typically makes up the primary key of a Sixth Normal Form table?

    Question 5
  6. 6. What is the difference between transaction-time and valid-time in bi-temporal modelling?

    Question 6
  7. 7. Which modelling techniques are named as embracing Sixth Normal Form style fine-grained decomposition?

    Question 7
  8. 8. Which of the following is NOT a benefit attributed to Sixth Normal Form?

    Question 8
  9. 9. For which scenarios is Sixth Normal Form said to be best suited?

    Question 9
  10. 10. How do many organisations apply Sixth Normal Form in practice?

    Question 10