Which of the following describes 'many-to-many' relationship in a database?
A
One record relates to one record only
B
One record relates to many records only
C
Multiple records in one table relate to multiple in another
D
No relationship exists
Correct Answer: Option C — Multiple records in one table relate to multiple in another
Explanation:
A many-to-many relationship occurs when multiple records in one table can relate to multiple records in another table, typically implemented...
A many-to-many relationship occurs when multiple records in one table can relate to multiple records in another table, typically implemented using a junction table.