Question

How do you implement a one-to-many relationship in a relational database? LO 5-6

a. Post a foreign key.
b. Create a new table.
c. Combine two fields to create a primary key.
d. Create an association.
e. None of the above

Answer 1

A one-to-many relationship in a relational database is implemented by post a foreign key.

Step-by-step explanation:

A one-to-many relationship in a relational database is implemented by post a foreign key. A foreign key is a field in a table that refers to the primary key of another table. By adding a foreign key column in the 'many' side table, you can establish a link between the 'one' side table and the 'many' side table. This allows you to associate multiple rows in the 'many' side table with a single row in the 'one' side table.