1NF – First Normal Form — Learn free

Self-check

Questions 1–10 of 10

1. What is the first formal rule that First Normal Form (1NF) introduces?
Question 1A. Every attribute must contain atomic, indivisible valuesB. Every non-key attribute must depend on the whole composite keyC. Every determinant must be a superkeyD. No non-key attribute may depend on another non-key attributeE. Every table must have a surrogate primary key
2. In First Normal Form, what must each row of a table represent?
Question 2A. A summary of several related entitiesB. A single instance of an entityC. A repeating group of valuesD. A complete customer historyE. One column of the original spreadsheet
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?
Question 3A. The dates are moved into a separate Customer tableB. The dates are concatenated into a single text fieldC. Each repayment instance becomes a separate rowD. The dates are replaced by a count of repaymentsE. The dates are stored as an array column
4. After applying First Normal Form to a table with repeating groups, in which direction does the table grow?
Question 4A. Horizontally, gaining more columnsB. It shrinks in both directionsC. It stays exactly the same sizeD. Vertically, gaining more rowsE. It is split into a star schema
5. In the loan example under First Normal Form, which composite key might initially identify repayment entries uniquely?
Question 5A. CustID combined with CustomerNameB. LoanAmount combined with RepaymentAmountC. ProductType combined with InterestRateD. CustomerAddress combined with LoanIDE. LoanID combined with RepaymentDate
6. Which of the following does First Normal Form NOT do?
Question 6A. Remove repeating groupsB. Eliminate redundancy between related entitiesC. Require atomic values in every cellD. Require every record to be uniquely identifiableE. Make data structurally compatible with relational systems
7. Which problem can still exist in a table that satisfies First Normal Form?
Question 7A. Decision details that depend on other non-key attributesB. Multiple values stored in a single cellC. Rows that cannot be uniquely identifiedD. Repeating groups inside a rowE. Lists stored inside a column
8. What transition does the move from Unnormalized Form to First Normal Form represent?
Question 8A. The shift from relational tables to document storageB. The shift from a transactional to an analytical modelC. The shift from loosely structured data to properly formed relational tablesD. The shift from a composite key to a surrogate keyE. The shift from atomic values to repeating groups
9. Why must a primary key be defined when a table is brought into First Normal Form?
Question 9A. To allow the table to grow horizontallyB. To remove transitive dependenciesC. To link the table to a fact tableD. So that no two rows represent the same entity instanceE. So that multi-valued attributes can be stored safely
10. What structural problem is addressed in the normal form that follows First Normal Form?
Question 10A. Join dependenciesB. Multi-valued dependenciesC. Non-superkey determinantsD. Domain constraintsE. Partial dependencies