5. Databases Networks

Normalization — Quiz

Test your understanding of normalization with 5 practice questions.

Practice Questions

Question 1

Which normal form requires that every non-key attribute is fully functionally dependent on the primary key, meaning it cannot be dependent on only a part of a composite primary key?

Question 2

Consider a table 'Enrollment' with attributes (StudentID, CourseID, StudentName, CourseName). If the primary key is (StudentID, CourseID), and 'StudentName' depends only on 'StudentID', what normal form is violated?

Question 3

What is the primary characteristic of a table that is in Boyce-Codd Normal Form (BCNF)?

Question 4

Which of the following best describes a 'transitive dependency' in database normalization?

Question 5

To achieve Third Normal Form (3NF), a table must first be in 2NF and then eliminate which type of dependency?