One-to-Many Relationships

Concept

• In a one-to-many relationship, one record in a table relates to multiple records in another table.

Example

• User Table: Has a primary key userID.
• Workout Table: Includes a userID as a foreign key, linking many workouts to one user.

Source

• Wikipedia - Database Schema