• Register
0 votes
28 views

Problem:

In many-to-many relationships in a relational database design, ________?
A) the key of the child is placed as a foreign key into the parent
B) the key of the parent is placed as a foreign key into the child
C) the keys of both tables are placed in a third table
D) the keys of both tables are joined into a composite key
E) C and D

7.5k points

Please log in or register to answer this question.

1 Answer

0 votes

Solution:

The intersection table is ID-dependent on both of the parents
The minimum cardinality from the intersection table to the parents is always M

1.5k points
In systems analysis, a many-to-many relationship is a type of cardinality that refers to the relationship between two entities A and B in which A may contain a parent instance for which there are many children in B and vice versa. For example, think of A as Authors, and B as Books. A many-to-many relationship refers to a relationship between tables in a database when a parent row in one table contains several child rows in the second table and vice versa.