2NF – Second Normal Form

Share this topic

2NF – Second Normal Form

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Self-check

Questions 1–10 of 10

  1. 1. What kind of dependency does Second Normal Form (2NF) eliminate?

    Question 1
  2. 2. Which two conditions must a table satisfy to be in Second Normal Form?

    Question 2
  3. 3. When does the Second Normal Form rule become relevant?

    Question 3
  4. 4. What is a partial dependency?

    Question 4
  5. 5. In a repayment table keyed by (LoanID, RepayDate), why does storing LoanAmount violate Second Normal Form?

    Question 5
  6. 6. What practical problem arises when LoanAmount is stored alongside every repayment record?

    Question 6
  7. 7. How does Second Normal Form resolve a partial dependency in the loan approval example?

    Question 7
  8. 8. Which issue does Second Normal Form NOT address?

    Question 8
  9. 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?

    Question 9
  10. 10. What refinement does the move from First to Second Normal Form represent?

    Question 10