5NF – Fifth Normal Form — Learn free

Self-check

Questions 1–10 of 10

1. By what other name is Fifth Normal Form (5NF) known?
Question 1A. Projection–Join Normal Form (PJNF)B. Domain–Key Normal Form (DKNF)C. Boyce–Codd Normal Form (BCNF)D. Temporal Normal FormE. Multi-Valued Normal Form
2. What kind of dependency does Fifth Normal Form address?
Question 2A. Functional dependenciesB. Join dependenciesC. Partial dependenciesD. Transitive dependenciesE. Multi-valued dependencies
3. What is the formal condition for a table to be in Fifth Normal Form?
Question 3A. It is in BCNF and has no multi-valued dependenciesB. It is in 3NF and every determinant is a superkeyC. It is in 4NF and every join dependency is implied by the candidate keys aloneD. It is in 6NF and every attribute has a validity periodE. It is in 1NF and every cell is atomic
4. In the Fifth Normal Form loan example, into which three binary tables can LoanGuarantorCollateral (LoanID, GuarantorID, CollateralType) be decomposed?
Question 4A. Loan, Guarantor and CollateralB. LoanAmount, LoanInterestRate and LoanStatusC. Customer, Loan and RepaymentD. LoanGuarantor, LoanCollateral and GuarantorCollateralE. LoanID, GuarantorID and CollateralType
5. When should a table be decomposed into its projections under Fifth Normal Form?
Question 5A. Whenever the table has more than three columnsB. Whenever the table has a composite keyC. Whenever the table stores time-varying attributesD. Whenever the table contains a foreign keyE. When its information equals the natural join of its projections and that dependency is not enforced by keys alone
6. Which two conditions must a Fifth Normal Form decomposition satisfy?
Question 6A. The joined smaller tables recreate the original facts exactly, and no smaller table contains redundant data internallyB. Every table has a surrogate key, and every attribute has an effective dateC. The smaller tables share no columns, and each has a single-column keyD. The decomposition reduces row count, and every table has fewer than three columnsE. Every constraint is a domain or key constraint, and no joins are required
7. What is the key difference between Fourth Normal Form and Fifth Normal Form?
Question 7A. 4NF applies to warehouses whereas 5NF applies to transactional systemsB. 4NF handles independent multi-valued facts about the same key, whereas 5NF handles redundancy that emerges through join patterns involving three or more attributesC. 4NF removes transitive dependencies whereas 5NF removes partial dependenciesD. 4NF requires time validity whereas 5NF does notE. 4NF is theoretical whereas 5NF is used in every schema
8. In which kinds of domains does Fifth Normal Form become relevant?
Question 8A. Simple one-to-many hierarchiesB. Read-only reporting tablesC. Highly structured domains with complex many-to-many-to-many relationships where associations are fully independentD. Document databases with embedded arraysE. Every everyday transactional system
9. What should be done if business rules constrain which loan guarantor and collateral combinations are allowed?
Question 9A. Decompose to the pure cross-product anywayB. Store the combinations as a comma-separated listC. Drop the constraint and rely on application logicD. Model the constraint with an explicit association table rather than pretending the relationships are independentE. Move the constraint into a domain definition
10. Conceptually, what kind of relationships does a table in Fifth Normal Form contain?
Question 10A. Only one-to-one relationshipsB. Only relationships with explicit time validityC. Only relationships enforced by domain constraintsD. Only denormalised relationships for query speedE. Only irreducible relationships that cannot be further decomposed without losing information