When each record in the first table matches at most one record in the second table,and each record in the second table matches at most one record in the first table,a(n)____ relationship exists between the two tables
A)one-to-one
B)one-to-many
C)many-to-many
D)many-to-one

Question

Quizplus · Accepted Answer

As per the given conditions, each record in the first table matches at most one record in the second table, and each record in the second table matches at most one record in the first table. This implies that there is a unique correspondence between the records of both tables. Hence, a one-to-one relationship exists between the two tables.

When Each Record in the First Table Matches at Most