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