Solution:Step 1: Identify 2NF violationStudentName depends only on StudentID, CourseName only on CourseID, causing partial dependencies.Step 2: Fix by splitting tablesSplitting into Students(StudentID, StudentName), Courses(CourseID, CourseName), and Enrollment(StudentID, CourseID) removes partial d

[Solved] You have this table:CREATE TABLE Enrollment (StudentID INT, CourseID INT, StudentName VARCHAR(50), CourseName VARCHAR(50), PRIMARY KEY (StudentID, CourseID));Which change fixes the 2NF violation? | SQL

SQL - Database Design and Normalization

You have this table:

CREATE TABLE Enrollment (StudentID INT, CourseID INT, StudentName VARCHAR(50), CourseName VARCHAR(50), PRIMARY KEY (StudentID, CourseID));

Which change fixes the 2NF violation?

AKeep the table as is; 2NF is not violated.

BAdd StudentName and CourseName as part of the primary key.

CRemove the composite key and use a single primary key.

DSplit into three tables: Students(StudentID, StudentName), Courses(CourseID, CourseName), and Enrollment(StudentID, CourseID).

Step-by-Step Solution

Solution:

Step 1: Identify 2NF violation
StudentName depends only on StudentID, CourseName only on CourseID, causing partial dependencies.
Step 2: Fix by splitting tables
Splitting into Students(StudentID, StudentName), Courses(CourseID, CourseName), and Enrollment(StudentID, CourseID) removes partial dependencies, achieving 2NF.
Final Answer:
Split into three tables: Students(StudentID, StudentName), Courses(CourseID, CourseName), and Enrollment(StudentID, CourseID). -> Option D
Quick Check:
Split tables to remove partial dependencies [OK]

Quick Trick: Split tables to fix partial dependencies [OK]

Common Mistakes:

Adding non-key columns to primary key
Removing composite key incorrectly
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

You have this table:

Step 1: Identify 2NF violation

Step 2: Fix by splitting tables

Final Answer:

Quick Check:

Want More Practice?