Deep Dive into Normalization Forms — Learn free

Self-check

Questions 1–10 of 10

1. What is the correct order of the full normalisation ladder?
Question 1A. UNF → 1NF → 2NF → 3NF → BCNF → 4NF → 5NF → 6NF → DKNFB. 1NF → UNF → 2NF → BCNF → 3NF → 4NF → 5NF → 6NF → DKNFC. UNF → 1NF → 2NF → 3NF → 4NF → BCNF → 5NF → DKNF → 6NFD. DKNF → 6NF → 5NF → 4NF → BCNF → 3NF → 2NF → 1NF → UNFE. UNF → 1NF → 3NF → 2NF → BCNF → 4NF → 5NF → 6NF → DKNF
2. Which of the following is NOT one of the consistent objectives of normalisation across the ladder?
Question 2A. Eliminate redundancyB. Prevent update, insert and delete anomaliesC. Increase structural integrityD. Prepare the model for specialised architectural useE. Minimise the number of joins in reports
3. What does First Normal Form (1NF) require?
Question 3A. Removal of transitive dependenciesB. Every determinant to be a candidate keyC. Removal of multi-valued dependenciesD. Elimination of repeating groups and atomic, indivisible values in each columnE. Each table to store a single attribute
4. What does Second Normal Form (2NF) remove?
Question 4A. Transitive dependenciesB. Join dependenciesC. Partial dependencies, so every non-key attribute depends on the entire primary keyD. Multi-valued dependenciesE. Repeating groups
5. What does Third Normal Form (3NF) eliminate?
Question 5A. Repeating groupsB. Partial dependenciesC. Transitive dependencies, so non-key attributes depend only on the key and not on other non-key attributesD. Join dependenciesE. Domain constraints
6. What does Boyce-Codd Normal Form (BCNF) require?
Question 6A. That every determinant be a candidate keyB. That every column be atomicC. That every table store a single factD. That there be no join dependenciesE. That all constraints be expressed through domains
7. Which normal form removes multi-valued dependencies?
Question 7A. 2NFB. 3NFC. BCNFD. 4NFE. 5NF
8. What does Fifth Normal Form (5NF) ensure?
Question 8A. That each column is atomicB. That every determinant is a candidate keyC. That each table stores a single attributeD. That repeating groups are removedE. That decomposed tables can only be recombined in one correct way without introducing spurious data
9. Which specialised approaches are influenced by higher normal forms such as 6NF?
Question 9A. Star and snowflake schemasB. Temporal modelling and ensemble approaches like Data Vault, Anchor Modelling and Focal Point ModellingC. BPMN and process modellingD. Taxonomies and ontologiesE. Canonical data models
10. In the loan approval case study for the normalisation ladder, what is the starting structure?
Question 10A. Four already-normalised tablesB. A single messy flattened table containing all Customer, Loan, ApprovalDecision and RepaymentSchedule informationC. A star schema with one fact tableD. A knowledge graph of customersE. A set of natural-language sentences