Which of the following is the correct way to represent a one-to-many relationship in tables derived from an ER diagram?

easy📝 Syntax Q12 of 15

SQL - Table Relationships

ACreate a new table with only primary keys from both tables

BAdd a foreign key column in the 'many' side table referencing the 'one' side

CAdd a foreign key column in the 'one' side table referencing the 'many' side

DUse a trigger to link the two tables

Step-by-Step Solution

Solution:

Step 1: Understand one-to-many relationship
One-to-many means one record in the first table relates to many records in the second table.
Step 2: Map relationship to tables
The 'many' side table gets a foreign key column referencing the 'one' side table's primary key.
Final Answer:
Add a foreign key column in the 'many' side table referencing the 'one' side -> Option B
Quick Check:
Foreign key on 'many' side = Add a foreign key column in the 'many' side table referencing the 'one' side [OK]

Quick Trick: Foreign key goes in the 'many' side 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