Question

question 35 (2 points) saved
listen
when transformed to a relational database design, many-to-many relationships are represented by .

1. two tables with an m:n relationship
2. two tables with a 1:n relationship
3. an intersection table which has m:n relationships with the two tables
4. an intersection table which has 1:n relationships with the two tables

Explanation:

To solve this, we recall database design concepts: In relational database design, a many - to - many (M:N) relationship between two entities (tables) is resolved by creating an intersection (junction) table. This intersection table has a one - to - many (1:N) relationship with each of the two original tables.

• Option 1 is incorrect because we can't directly represent M:N with two tables in a relational database (we need the intersection table).
• Option 2 is incorrect as a 1:N relationship is not used to represent M:N relationships.
• Option 3 is incorrect because the intersection table has 1:N relationships with the two tables, not M:N.
• Option 4 is correct as the intersection table creates two 1:N relationships (from the intersection table to each of the original tables) to resolve the M:N relationship between the two original tables.

Answer:

1. an intersection table which has 1:N relationships with the two tables