Normal Forms   «Prev  Next»

Database Normalization - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. A relation is in 1NF if it doesn't contain any ____________?
Please select the best answer.
  A. Determinants
  B. Repeating groups
  C. Null values in primary key fields
  D. Functional dependencies

2. A table is in 2NF if the table is in 1NF and what other condition is met?
Please select the best answer.
  A. There are no functional dependencies.
  B. There are no null values in primary key fields.
  C. There are no repeating groups.
  D. There are no attributes that are not functionally dependent on the relation's primary key.

3. When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?
Please select all the correct answers.
  A. Link the relations by a common field
  B. Remove any functional dependencies from both relations
  C. Assign both relations the same primary key field(s)
  D. Create a primary key(s) for the new relation

4. What characterizes a relational database table that is in First Normal Form (1NF)?
Please select the best answer.
  A. The table contains no repeating groups or arrays.
  B. The table allows null values in primary key columns.
  C. The table includes multiple values in a single column.
  D. The table contains summary rows and detailed rows together.