Bird
0
0

What is the main purpose of a junction table in a many-to-many relationship?

easy📝 Conceptual Q11 of 15
SQL - Table Relationships
What is the main purpose of a junction table in a many-to-many relationship?
ATo store pairs of related records from two tables using foreign keys
BTo store all data from both tables in one place
CTo replace one of the original tables completely
DTo create a one-to-one relationship between tables
Step-by-Step Solution
Solution:

  1. Step 1: Understand many-to-many relationships

    Many-to-many means each record in one table can relate to many records in another table, and vice versa.

  2. Step 2: Role of junction table

    A junction table holds pairs of foreign keys from both tables to link related records without duplicating data.

  3. Final Answer:

    To store pairs of related records from two tables using foreign keys -> Option A

  4. Quick Check:

    Junction table = pairs of foreign keys [OK]
Quick Trick: Junction tables link two tables with pairs of keys [OK]
Common Mistakes:
MISTAKES
  • Thinking junction table stores all data from both tables
  • Confusing junction table with a single main table
  • Assuming junction table creates one-to-one links

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
GROUP BY and HAVING - Why grouping is needed - Quiz 1easy INNER JOIN - INNER JOIN with table aliases - Quiz 7medium LEFT and RIGHT JOIN - Multiple LEFT JOINs in one query - Quiz 5medium LEFT and RIGHT JOIN - Finding unmatched rows with LEFT JOIN - Quiz 11easy Set Operations - Why set operations are needed - Quiz 5medium Subqueries - Subquery in FROM clause (derived table) - Quiz 9hard Subqueries - Subquery vs JOIN performance trade-off - Quiz 12easy Table Constraints - Foreign key ON DELETE behavior - Quiz 13medium Views - Querying through views - Quiz 12easy Views - Querying through views - Quiz 15hard