One-to-Many
How a one-to-many relationship links many child rows to one parent row through a foreign key, like a customer and their orders.
Apprentice · SQL · Database · Updated
The One-to-Many relationship is the most common type of relationship in a database. In a One-to-Many relationship, a row in the parent table can be related to one or more rows in the child table. The relationship is created by having the foreign key in a child table refer to the primary key of the parent table.
For example, a customer can place many orders. The Customer table is the parent table and the Order table is the child.
