A ____ relationship occurs when the primary key field of one table is related to the primary key field of another table.
A) one-to-many
B) many-to-one
C) one-to-one
D) many-to-many

Question

Quizplus · Accepted Answer

A one-to-one relationship occurs when a single record in the first table is directly related to a single record in the second table. This relationship is defined by the primary key of both tables. In this case, the primary key of one table is related to the primary key in another table, resulting in a one-to-one relationship. The other options (one-to-many, many-to-one, many-to-many) describe different types of relationships where multiple records in one table can be related to one or more records in another table.

A ____ Relationship Occurs When the Primary Key Field of One