Question

Whenever there is a one-to-many relationship (regardless of the minimum constraints), place the primary key of the 'one' entity into the 'many' entity as a foreign key. True or False?

Answer 1

The primary key of the 'one' entity is placed as a foreign key in the 'many' entity in a one-to-many relationship.

Step-by-step explanation:

The statement is true. In a one-to-many relationship, the primary key of the 'one' entity is placed as a foreign key in the 'many' entity. This is done to establish a link between the two entities and maintain data integrity.

For example, let's consider a scenario where we have a 'Customers' table and an 'Orders' table. Each customer can have multiple orders, so there is a one-to-many relationship between the 'Customers' and 'Orders' tables.

In this case, we would place the primary key of the 'Customers' table (e.g., customer_id) as a foreign key in the 'Orders' table to establish the relationship.