Multiple choice technology packaged enterprise solutions

Which type of relationship requires an intersection table?

  1. Many-to-One (M:1)

  2. One-to-One (1:1)

  3. Many-to-Many (M:M)

  4. One-to-Many (1:M)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A Many-to-Many relationship cannot be represented directly with foreign keys in a standard relational database without duplication. An intersection (junction) table containing foreign keys referencing both tables is required to resolve it.

Keep practicing — related questions