# One-to-Many Relationship

*noun*

say it: **“WUN too MEN-ee rih-LAY-shun-ship”** **/wʌn tuː ˈmɛni rɪˈleɪʃənʃɪp/**

A link where one row in a table can be linked to many rows in another, such as one customer with many orders.

## What is **One-to-Many Relationship** in a relational database?

**One-to-Many Relationship** — A relationship where one parent row can relate to many child rows.

```sql
CREATE TABLE purchase_order (
    order_id INTEGER PRIMARY KEY,
    customer_id INTEGER REFERENCES customer (customer_id)
);
```

## In a sentence

- “Customers to Orders is a **one-to-many relationship**.”

Level: Novice · [More Database terms at this level](https://www.ask-codey.com/glossary?category=database&level=1)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/one-to-many-relationship
