The relational model represents data as tables of rows and columns. Each row records a fact, and a key can refer to a row in another table.
In the demo, an order joins the customer whose id matches customer_id. Explicit relationships avoid copying customer names into every order, but a missing join condition can create unwanted combinations.
When to use
Use it when related business records need consistent storage and SQL queries.