Which statement is true regarding a one-to-many relationship?
A)For each one record in one database table there is one record in the related table.
B)This type of relationship is problematic when building a database and must be eliminated using an intersection table.
C)One-to-many relationships are the most common type of relationships in a relational database.
D)Many records in one table relate to many records in a related table.

Question

Quizplus · Accepted Answer

One-to-many relationships are the most common type of relationships in a relational database. In this type of relationship, each record in one table can relate to multiple records in a related table, but each record in the related table can have only one relationship with the original table. Option A is incorrect because a one-to-many relationship implies that there are multiple related records for each record in the original table. Option B is incorrect because there are cases where a one-to-many relationship is perfectly fine without needing an intersection table. Option D is incorrect because it describes a many-to-many relationship.

Which Statement Is True Regarding a One-To-Many Relationship