[Solved] Consider the following table:CREATE TABLE ProductOrders (OrderID INT, ProductID INT, ProductDescription VARCHAR(100), Quantity INT, PRIMARY KEY (OrderID, ProductID));Which statement is true regarding... | SQL

SQL - Database Design and Normalization

Consider the following table:

CREATE TABLE ProductOrders (OrderID INT, ProductID INT, ProductDescription VARCHAR(100), Quantity INT, PRIMARY KEY (OrderID, ProductID));

Which statement is true regarding its 2NF compliance?

AIt violates 2NF because ProductDescription depends only on ProductID.

BIt is in 2NF because all columns depend on the full primary key.

CIt violates 2NF because Quantity depends only on OrderID.

DIt is in 2NF because ProductDescription is a key attribute.

Step-by-Step Solution

Solution:

Step 1: Identify primary key
The primary key is composite: (OrderID, ProductID).
Step 2: Check dependencies
ProductDescription depends only on ProductID, a part of the key, causing partial dependency.
Final Answer:
It violates 2NF because ProductDescription depends only on ProductID. -> Option A
Quick Check:
Partial dependency found on ProductDescription [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

Consider the following table: