A relationship between tables in which a record in one table has only one matching record in the second table is a ________.
A) 1:N
B) M:N
C) 1:1
D) There would not be a relationship between the two tables.

Question

Quizplus · Accepted Answer

A 1:1 relationship is also known as a one-to-one relationship, and it means that a record in one table has only one matching record in the second table. This type of relationship is most commonly used when it is necessary to split a large table into two smaller tables, but still maintain a strict one-to-one relationship between the data in those tables. The other options, 1:N and M:N relationships, imply that a record in one table can have multiple matching records in the second table, which is not what is described in the question. And if there were no relationship between the two tables, then there would be no way to link the data in those tables together, which defeats the purpose of using a database in the first place.

A Relationship Between Tables in Which a Record in One