Skills101
← All practice quizzes

Quiz: Normalization

5 questionsNo time limitPass: 60%+10 XP on first pass

Remove repeated data step by step. Functional dependencies, anomalies, and one table taken through 1NF, 2NF, 3NF and BCNF — the way interviewers expect.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    A table where one cell contains "Python, Java, SQL" violates:

  2. Question 2

    Key (order_id, product_id); column customer_name depends only on order_id. This violates:

  3. Question 3

    emp_id → dept_id and dept_id → dept_name in one table. dept_name violates:

  4. Question 4

    "You can't add a new course until a student registers" is an example of a:

  5. Question 5

    A table whose primary key is a single column is automatically in: