Which of the following statements best describes a one-to-many relationship between two tables?
A) A primary key in the first table matches several foreign keys in the second table.
B) A foreign key in the first table matches several primary keys in the second table.
C) A primary key in the first table matches exactly one foreign key in the second table.
D) Primary and foreign keys have multiple cross matches between a first and second table.

Question

Quizplus · Accepted Answer

A one-to-many relationship occurs when a single record in the first table (identified by its primary key) can be associated with multiple records in the second table (where these associations are identified by the foreign key in the second table).

Which of the Following Statements Best Describes a One-To-Many Relationship