Third Normal Form   «Prev  Next»

Third Normal Form - Quiz

Select the best answer or answers for each question.
 

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


2. Which of the following are goals of denormalization?
Please select all the correct answers.
  A. To improve the performance of all searches and queries
  B. To improve the performance of selected searches and queries
  C. To reduce unnecessary complexity
  D. To decrease the number of times tables must be combined

3. The jingle you learned gives the guidelines for which normal forms?
Please select all the correct answers.
  A. 1NF
  B. 2NF
  C. 3NF
  D. 4NF