An example of a ____ relationship is when sensitive information such as emergency contact information must be separated from basic demographic data in two tables that are related by their primary key fields.
A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Question

Quizplus · Accepted Answer

A one-to-one relationship is the best choice in this scenario because one person's emergency contact information should only be associated with their specific demographic data. This ensures that the sensitive information is kept separate from any additional data that may be stored in the table. Using a one-to-many or many-to-many relationship would create unnecessary redundancy and increase the risk of errors or data inconsistencies.

An Example of a ____ Relationship Is When Sensitive Information