The most common type of relationship to set up is a(n) ____ relationship, in which the primary key field in one table is associated with multiple records in a second table.
A) one-to-one
B) referential
C) one-to-many
D) integral

Question

Quizplus · Accepted Answer

A one-to-many relationship is the most common type of relationship between two tables in a relational database. It happens when a record in one table corresponds to multiple records in another table. This is achieved by linking the primary key of one table to a foreign key in another table. For example, a customer may have multiple orders associated with them in an e-commerce database.

The Most Common Type of Relationship to Set Up Is