3. Database Design

Normalization — Quiz

Test your understanding of normalization with 5 practice questions.

Practice Questions

Question 1

Which normal form is violated when a non-key attribute is functionally dependent on a part of a composite primary key?

Question 2

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

Question 3

A table is in Third Normal Form (3NF) if it is in 2NF and eliminates which type of dependency?

Question 4

Which of the following is an example of a transitive dependency?

Question 5

What is the primary goal of Boyce-Codd Normal Form (BCNF)?