[Solved] Which SQL table design violates Second Normal Form (2NF)?CREATE TABLE Orders (OrderID INT, ProductID INT, ProductName VARCHAR(50), Quantity INT, PRIMARY KEY (OrderID, ProductID)); | SQL

SQL - Database Design and Normalization

Which SQL table design violates Second Normal Form (2NF)?

CREATE TABLE Orders (OrderID INT, ProductID INT, ProductName VARCHAR(50), Quantity INT, PRIMARY KEY (OrderID, ProductID));

AOrderID and ProductID together form the primary key.

BQuantity depends on both OrderID and ProductID.

CProductName depends only on ProductID, not the whole key.

DThe table has a composite primary key.

Step-by-Step Solution

Solution:

Step 1: Identify dependencies in the table
ProductName depends only on ProductID, which is part of the composite key (OrderID, ProductID).
Step 2: Check 2NF violation
Since ProductName depends on part of the key, this violates 2NF which forbids partial dependencies.
Final Answer:
ProductName depends only on ProductID, not the whole key. -> Option C
Quick Check:
Partial dependency = 2NF violation [OK]

Quick Trick: Check if non-key columns depend on part of composite key [OK]

Common Mistakes:

Master "Database Design and Normalization" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which SQL table design violates Second Normal Form (2NF)?