DKNF – Domain–Key Normal Form — Learn free

Self-check

Questions 1–10 of 10

1. When is a relation in Domain–Key Normal Form (DKNF)?
Question 1A. When every constraint on the table can be expressed solely as a domain constraint or a key constraintB. When every attribute has its own time-aware tableC. When every join dependency is implied by candidate keysD. When every non-key attribute depends on the whole keyE. When no two independent multi-valued facts share a key
2. What does a domain constraint define?
Question 2A. Which combination of attributes uniquely identifies a rowB. What values are valid for a columnC. How tables are joined togetherD. Which table owns a foreign keyE. The order in which rows are stored
3. What does a key constraint define?
Question 3A. Valid values for a columnB. The data type of a columnC. Uniqueness: which combination of attributes uniquely identifies a rowD. Whether a column may be nullE. The validity period of a fact
4. Why does the rule "If a loan is APPROVED, it must have a RepaymentSchedule" prevent a schema from reaching Domain–Key Normal Form?
Question 4A. Because it is a domain constraint on the wrong columnB. Because it is a key constraint on a composite keyC. Because APPROVED is not a valid domain valueD. Because it is a cross-table conditional rule that is neither purely a domain constraint nor purely a key constraintE. Because repayment schedules cannot be modelled relationally
5. Why do most real-world schemas not reach Domain–Key Normal Form?
Question 5A. Because databases do not support domain constraintsB. Because DKNF requires more tables than 6NFC. Because DKNF forbids composite keysD. Because DKNF only applies to NoSQL systemsE. Because many business rules are conditional or cross-entity and need triggers, application logic or procedural enforcement
6. Between which normal forms do most practical systems stabilise?
Question 6A. Between 3NF and BCNF, occasionally extending to 4NF or 6NFB. Between 1NF and 2NFC. Between 5NF and DKNFD. Always at 6NFE. Always at DKNF
7. According to the comparison of normalisation with specialised modelling techniques, how does dimensional modelling relate to normal forms?
Question 7A. It requires 5NF or 6NF for accuracyB. It is the opposite: intentional denormalisation for analytical performanceC. It is explicitly grounded in 6NF principlesD. Normalisation is not applicable because it predates the relational modelE. It satisfies DKNF by design
8. Which modelling technique is described as explicitly grounded in 6NF-style decomposition and temporal principles?
Question 8A. Hierarchical modellingB. Event-driven modellingC. Anchor ModellingD. API / service modellingE. Object-oriented modelling
9. Which of the following techniques is NOT listed as one where normalisation theory is simply not applicable?
Question 9A. Hierarchical and network modellingB. Object-oriented modellingC. NoSQL modellingD. Data Vault modellingE. Event-driven modelling
10. What is the central question that changes when moving from foundational normalisation to specialised modelling techniques?
Question 10A. From "Which database vendor?" to "Which cloud platform?"B. From "How many tables?" to "How many rows?"C. From "Is the key composite?" to "Is the key surrogate?"D. From "Is the data atomic?" to "Is the data historical?"E. From "Is the model fully normalised?" to "What problem is this model designed to solve?"