2NF – Second Normal Form
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What kind of dependency does Second Normal Form (2NF) eliminate?
2. Which two conditions must a table satisfy to be in Second Normal Form?
3. When does the Second Normal Form rule become relevant?
4. What is a partial dependency?
5. In a repayment table keyed by (LoanID, RepayDate), why does storing LoanAmount violate Second Normal Form?
6. What practical problem arises when LoanAmount is stored alongside every repayment record?
7. How does Second Normal Form resolve a partial dependency in the loan approval example?
8. Which issue does Second Normal Form NOT address?
9. According to the rule for achieving Second Normal Form, what should be done with an attribute that depends on only part of the key?
10. What refinement does the move from First to Second Normal Form represent?