I'm creating a database for a Pizza store as a exercise for school, and am struggling with creating the tables, and what to put in them.
I'm supposed to design a database and focus on the order entry and delivery aspect, the orders can have multiple toppigs per pizza, different prices for different toppings, multiple pizzas per order, and include other non pizza items (such as soda, fries, etc).
I'm thinking of the following tables:
tbl_customer - customer id, name, address, city, state, zip, phone, etc
tbl_order - order id, customer id, order date
tbl_orders_details - ???
tbl_menu - ???
tbl_toppings - ???
but i'm not too sure what they should include.
help?!?!