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.

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

Updated