1NF – First 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 is the first formal rule that First Normal Form (1NF) introduces?
2. In First Normal Form, what must each row of a table represent?
3. How does applying First Normal Form change the storage of multiple repayment dates such as "Jan-31, Feb-28" in the loan approval example?
4. After applying First Normal Form to a table with repeating groups, in which direction does the table grow?
5. In the loan example under First Normal Form, which composite key might initially identify repayment entries uniquely?
6. Which of the following does First Normal Form NOT do?
7. Which problem can still exist in a table that satisfies First Normal Form?
8. What transition does the move from Unnormalized Form to First Normal Form represent?
9. Why must a primary key be defined when a table is brought into First Normal Form?
10. What structural problem is addressed in the normal form that follows First Normal Form?