pizza_order
topping
pizza_size
id
sizeid (FK)
room
status
order_topping
id
name
orderid (FK)
toppingid (FK)
id
name
PizzaOrder
Topping
PizzaSize
0..*
0..*
0..*
Classic Relationships
Schema mapping, entities to tables and vice versa
Needed database schema:
has one table for each
entity, plus a link table for
N-N relationship
1
18