DKNF – Domain–Key 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. When is a relation in Domain–Key Normal Form (DKNF)?
2. What does a domain constraint define?
3. What does a key constraint define?
4. Why does the rule "If a loan is APPROVED, it must have a RepaymentSchedule" prevent a schema from reaching Domain–Key Normal Form?
5. Why do most real-world schemas not reach Domain–Key Normal Form?
6. Between which normal forms do most practical systems stabilise?
7. According to the comparison of normalisation with specialised modelling techniques, how does dimensional modelling relate to normal forms?
8. Which modelling technique is described as explicitly grounded in 6NF-style decomposition and temporal principles?
9. Which of the following techniques is NOT listed as one where normalisation theory is simply not applicable?
10. What is the central question that changes when moving from foundational normalisation to specialised modelling techniques?