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..*
Pizza Shop Entities, Mapping
Needed database schema:
has one table for each
entity, plus a link table for
N-N relationship
1
34
SysTime
sys_time
id
current_day
report_day