3NF – Third Normal Form — Learn free

Self-check

Questions 1–10 of 10

1. What kind of dependency does Third Normal Form (3NF) remove?
Question 1A. Transitive dependenciesB. Partial dependenciesC. Multi-valued dependenciesD. Join dependenciesE. Repeating groups
2. What is a transitive dependency?
Question 2A. An attribute that depends on only part of a composite keyB. A non-key attribute that depends on another non-key attribute rather than directly on the primary keyC. A key that is made up of more than one columnD. A column that holds several values in one cellE. A foreign key that references its own table
3. In the dependency pattern A → B → C used to describe a transitive dependency, what does A represent?
Question 3A. A non-key attributeB. A foreign keyC. The primary keyD. A multi-valued attributeE. A derived attribute
4. In the loan approval example, which chain illustrates a transitive dependency in the Loan table?
Question 4A. RepayDate → LoanID → LoanAmountB. CustomerName → LoanID → CustIDC. ProductType → InterestRate → LoanIDD. LoanID → CustID → CustomerNameE. CustID → LoanID → CustomerAddress
5. Why do CustomerName and CustomerAddress not belong in the Loan table under Third Normal Form?
Question 5A. Because they are multi-valued attributesB. Because they form part of the composite keyC. Because they are derived from LoanAmountD. Because they are optional fieldsE. Because they are properties of the customer, not of the loan itself
6. How does Third Normal Form resolve the customer-detail dependency in the Loan table?
Question 6A. By moving CustomerName and CustomerAddress into a Customer table keyed by CustIDB. By making CustomerName part of the Loan primary keyC. By storing customer details as a JSON columnD. By deleting the CustID attribute from the Loan tableE. By duplicating the Loan table for each customer
7. What benefit follows from Third Normal Form when a customer's address changes?
Question 7A. The address is archived automaticallyB. It is updated in exactly one placeC. Every loan row is updated by a triggerD. The loan must be re-approvedE. A new composite key is generated
8. Which of the following is NOT part of the rule for achieving Third Normal Form?
Question 8A. Begin with a table that is already in 2NFB. Examine all non-key attributes carefullyC. Ensure that every determinant is a superkeyD. Move attributes that depend on another non-key attribute into a new tableE. Establish a foreign key relationship to maintain the connection
9. For which kind of system is Third Normal Form often considered sufficient?
Question 9A. Graph databasesB. Key–value storesC. Data warehouses built as star schemasD. Most transactional systemsE. Document databases
10. Which normal form addresses the subtle integrity problems that Third Normal Form may still allow?
Question 10A. First Normal FormB. Second Normal FormC. Unnormalized FormD. Domain–Key Normal FormE. Boyce–Codd Normal Form