Question

A ________ relationship is a relationship between tables in which one record in one table has many matching records in a second table, and one record in the related table has many matching records in the first table.

1) one-to-many
2) one-to-one
3) many-to-many
4) This doesn't apply to any relationship type.

Answer 1

The relationship where one record in a table is associated with many records in another table, and vice versa, is known as a many-to-many relationship.

Step-by-step explanation:

The relationship described in the question is a many-to-many relationship. In a many-to-many relationship, one record in a table can relate to many records in another table, and vice versa. To handle this type of relationship in databases, an intermediate table, also known as a junction or linking table, is often used.

This table contains foreign keys that reference the primary keys of the two tables that are being linked together, thus establishing a many-to-many relationship between them.