6NF – Sixth Normal Form — Learn free

Self-check

Questions 1–10 of 10

1. What guiding idea summarises Sixth Normal Form (6NF)?
Question 1A. One attribute, one timeline, one tableB. One entity, one table, one keyC. Every determinant is a superkeyD. Every constraint is a domain or key constraintE. One fact table, many dimension tables
2. What is the condition for a table to be in Sixth Normal Form?
Question 2A. It is in BCNF and has no multi-valued dependenciesB. It is in 5NF and has been decomposed so that each relation captures a single fact about a key, typically with explicit time validityC. It is in 3NF and all attributes are atomicD. It is in 4NF and every join dependency is implied by keysE. It is in DKNF and all constraints are structural
3. What temporal problem does Sixth Normal Form solve for a loan whose interest rate and status change independently?
Question 3A. The loan can no longer be uniquely identifiedB. The loan's attributes lose atomicityC. Storing both attributes with effective dates in one table makes updates complex and overlapping intervals hard to manageD. The interest rate becomes a multi-valued attributeE. The status cannot be stored as a domain value
4. In the Sixth Normal Form loan example, what columns does the LoanInterestRate table contain?
Question 4A. LoanID, InterestRate, ProductTypeB. LoanID, Amount, StatusC. ProductType, InterestRateD. LoanID, InterestRate, EffectiveStart, EffectiveEndE. LoanID, InterestRate, TransactionTime
5. What typically makes up the primary key of a Sixth Normal Form table?
Question 5A. A surrogate integer aloneB. The attribute value itselfC. The business key aloneD. A hash of all columnsE. The business key combined with a validity period, such as LoanID and EffectiveStart
6. What is the difference between transaction-time and valid-time in bi-temporal modelling?
Question 6A. Transaction-time is when the record was stored in the system; valid-time is when the fact is true in the business worldB. Transaction-time is the loan origination date; valid-time is the repayment dateC. Transaction-time is the effective end date; valid-time is the effective start dateD. Transaction-time applies to OLTP; valid-time applies to OLAPE. They are two names for the same timestamp
7. Which modelling techniques are named as embracing Sixth Normal Form style fine-grained decomposition?
Question 7A. Star schema, snowflake schema and Unified Star SchemaB. Data Vault, Anchor Modelling and Focal Point ModellingC. Hierarchical, network and object-oriented modellingD. Document, key–value and graph databasesE. JSON schema, XML schema and API modelling
8. Which of the following is NOT a benefit attributed to Sixth Normal Form?
Question 8A. Audit-grade temporal lineageB. Clean separation of independently changing attributesC. Fewer tables and simpler queriesD. Precise as-of queries and historical reconstructionE. Independent attribute evolution
9. For which scenarios is Sixth Normal Form said to be best suited?
Question 9A. General OLTP systems with simple CRUD operationsB. Static reference data that never changesC. Read-heavy reporting dashboardsD. Regulatory, audit, pricing and contract scenariosE. Key–value caching layers
10. How do many organisations apply Sixth Normal Form in practice?
Question 10A. They apply 6NF to every table in the schemaB. They avoid 6NF entirely in favour of star schemasC. They apply 6NF only to dimension tablesD. They replace 6NF with DKNFE. They normalise to 3NF or BCNF, then selectively apply 6NF-style histories only where needed