Assignment

Making a database for a gourmet burger restaurant called Burgers by Design. The restaurant owner, Bob, has been running his business with pen-and-paper, but has decided to switch to an IPoS (Internet Point of Sales) System. This system will allow users to make an account and order their burgers either online (for pick up) or in store using a tablet.

Burgers by Design allows users to build their burgers by paying for each part of the burger separately. Bob wants all of his menu information to be included in the database: items, descriptions (not shown on the menu), prices, and allergen information. He also wants full user information for advertising: name, phone, email, address, etc. He also wants to keep track of what each user has ordered in the past, so that they can easily order it again.

This what I have done. Please if there are any mistakes or need to add any thing add it. with some explanation.

Thanks.

Pick Up Phone Number Address Email Last Name In store First Name Servise type Bill id Totale Price Coustomer id Order id Bill Place Date Time total price Date Quantity Price Buns Price Name Order ld Patties Add On Cash Name Coustomer ID Bill id Bill id Price Add On Name Date Date Name