WHat should be the relationship between 4 entites cutomer, order, menu and order item?
0
I am creating Restaurant order placing app. I have 4 entites cutomer, order, menu and order item. What should be the relationship between each of the entites? Please help me understand the relationship between them in details please
asked
Harsh Bhanushali
1 answers
3
one customer can make multiple orders
– thus Order_Customer should be one-to-many
one order has multiple ordered items
– thus OrderItem_Order should be one to many
Multiple orders can order the same menu.
– thus OrderItem_Menu should be one to many
answered
Peter Mudde