Which SQL statement correctly creates a junction table named StudentCourse linking Student and Course tables by their IDs?

easy📝 Syntax Q12 of 15

SQL - Table Relationships

Which SQL statement correctly creates a junction table named StudentCourse linking Student and Course tables by their IDs?

ACREATE TABLE StudentCourse (StudentID INT, CourseID INT, FOREIGN KEY (StudentID) REFERENCES Student(ID));

BCREATE TABLE StudentCourse (ID INT PRIMARY KEY, StudentID INT, CourseID INT);

CCREATE TABLE StudentCourse (StudentID INT UNIQUE, CourseID INT UNIQUE);

DCREATE TABLE StudentCourse (StudentID INT, CourseID INT, PRIMARY KEY (StudentID, CourseID));

Step-by-Step Solution

Solution:

Step 1: Define junction table columns
It needs two columns for foreign keys: StudentID and CourseID.
Step 2: Set primary key on both columns
Primary key on (StudentID, CourseID) ensures unique pairs and no duplicates.
Final Answer:
CREATE TABLE StudentCourse (StudentID INT, CourseID INT, PRIMARY KEY (StudentID, CourseID)); -> Option D
Quick Check:
Junction table needs composite primary key [OK]

Quick Trick: Use composite primary key on both foreign keys [OK]

Common Mistakes:

MISTAKES

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes