[Solved] Identify the error in this table design violating 2NF:CREATE TABLE Orders (OrderID INT, ProductID INT, ProductName VARCHAR(50), PRIMARY KEY (OrderID, ProductID));ProductName depends only on ProductID. | SQL

SQL - Database Design and Normalization

Identify the error in this table design violating 2NF:
CREATE TABLE Orders (OrderID INT, ProductID INT, ProductName VARCHAR(50), PRIMARY KEY (OrderID, ProductID));
ProductName depends only on ProductID.

AThere is no error; table is in 2NF.

BOrderID should be the only primary key.

CProductName causes partial dependency on ProductID.

DProductName should be part of the primary key.

Step-by-Step Solution

Solution:

Step 1: Analyze dependency
ProductName depends only on ProductID, part of composite key.
Step 2: Identify 2NF violation
This partial dependency violates 2NF rules.
Final Answer:
ProductName causes partial dependency on ProductID. -> Option C
Quick Check:
Partial dependency breaks 2NF [OK]

Quick Trick: Partial dependency on part of key breaks 2NF [OK]

Common Mistakes:

Thinking primary key must be single column
Adding non-key columns to primary key
Ignoring partial dependencies

Master "Database Design and Normalization" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Identify the error in this table design violating 2NF:

Step 1: Analyze dependency

Step 2: Identify 2NF violation

Final Answer:

Quick Check:

Want More Practice?