Which SQL statement correctly creates a foreign key for a one-to-many relationship from Orders to Customers?

easy📝 Syntax Q12 of 15

SQL - Table Relationships

Which SQL statement correctly creates a foreign key for a one-to-many relationship from Orders to Customers?

AALTER TABLE Customers ADD FOREIGN KEY (OrderID) REFERENCES Orders(OrderID);

BALTER TABLE Customers ADD FOREIGN KEY (CustomerID) REFERENCES Orders(OrderID);

CALTER TABLE Orders ADD FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID);

DALTER TABLE Orders ADD FOREIGN KEY (OrderID) REFERENCES Customers(CustomerID);

Step-by-Step Solution

Solution:

Step 1: Identify the 'many' and 'one' tables
Orders is the 'many' side, Customers is the 'one' side in a one-to-many relationship.
Step 2: Add foreign key in 'many' table referencing 'one' table
The foreign key should be in Orders referencing Customers, so ALTER TABLE Orders ADD FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID); is correct.
Final Answer:
ALTER TABLE Orders ADD FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID); -> Option C
Quick Check:
Foreign key in 'many' table references 'one' table [OK]

Quick Trick: Foreign key goes in 'many' table pointing to 'one' table [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