Which of the following statements are true about one-to-many relationships? Select all the options that apply.

A) The primary key field is on the "one" side of a one-to-many relationship.
Between two tables.
B) A linking table connects the two related tables.
C) A record in one table may be related to many records in another table.
D) The foreign key field is on the "many" side of a one-to-many relationship.

One-to-many Relationships

A type of database relationship where a single record in one table can be associated with multiple records in another table.

Primary Key Field

A unique identifier for each record in a database table, used to ensure that each entry is distinct.

Foreign Key Field

A field in a database table that creates a link between two tables by referencing the primary key of another table, thereby establishing a relationship between the data.