[Solved] Which SQL statement correctly defines a table that can be checked for 2NF compliance? — Ans: CREATE TABLE Enrollment (StudentID INT, CourseID INT, Grade CHAR(2), PRIMARY... | SQL

SQL - Database Design and Normalization

Which SQL statement correctly defines a table that can be checked for 2NF compliance?

ACREATE TABLE Enrollment (StudentID INT, CourseID INT, Grade CHAR(2), PRIMARY KEY StudentID, CourseID);

BCREATE TABLE Enrollment (StudentID INT, CourseID INT, Grade CHAR(2), PRIMARY KEY (StudentID, CourseID));

CCREATE TABLE Enrollment (StudentID INT, CourseID INT, Grade CHAR(2), PRIMARY KEY StudentID);

DCREATE TABLE Enrollment (StudentID INT, CourseID INT, Grade CHAR(2));

Step-by-Step Solution

Solution:

Step 1: Check syntax for composite primary key
Correct syntax uses PRIMARY KEY (StudentID, CourseID) with parentheses.
Step 2: Identify valid SQL statement
CREATE TABLE Enrollment (StudentID INT, CourseID INT, Grade CHAR(2), PRIMARY KEY (StudentID, CourseID)); correctly defines composite key; others have syntax errors or missing keys.
Final Answer:
CREATE TABLE Enrollment (StudentID INT, CourseID INT, Grade CHAR(2), PRIMARY KEY (StudentID, CourseID)); -> Option B
Quick Check:
Composite key syntax requires parentheses [OK]

Quick Trick: Composite keys need parentheses in PRIMARY 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 statement correctly defines a table that can be checked for 2NF compliance?