Question: For this assignment you will creating an Entity Relationship diagram for a described database. You will want to carefully consider the design of this diagram,

For this assignment you will creating an Entity Relationship diagram for a described database. You will want to carefully consider the design of this diagram, as you may not get it right on the first try. This is an individual assignment. For this assignment you will be designing the database for Anton's Pizzeria, a local pizza restaurant located in Anderson SC. The database needs to track order information, customer information, wait staff information, and the inventory of the current ingredients/toppings. Orders can be for dine in, which means they are taken by a waiter (who has a first and last name) and orders taken by a waiter have a table number associated with them. Orders can also be placed by the customer for delivery or carryout. In that case we need the customer information. Orders should have a bill amount, which is based on the costs of the pizzas on the order. This amount can change (A dine-in table could place an order, then add to it before paying the bill). Customers have at a minimum a first and last name and a phone number to reach them at. Customers could also have an email (if they have ordered online), and a physical address (street, city, state and zip) if they have ordered delivery. That information is saved for future orders as well. Pizzas will have a crust option (thin, original, pan), a size (personal, medium, large, extra large) and several toppings. The pizza will also have a price, which is based off of the size of the pizza and the toppings selected. Toppings have a name, a price for the customer, a price to purchase (for the restaurant) and a current level in the inventory. If a topping price to the customer changes, the price of past pizzas does not change. The bill amount for an order can change, because if someone is dining in at the restaurant they could place an order, and then add another pizza to it later. Anton's Pizzeria only serves Pizza, so your database does not need to track any other types of food or beverages. All pizzas at Anton's are "build your own" and there are no specialty pizzas or discounts. You do not need to create the database schema, or create the database in Access yet. We will do that for a later assignment. You can hand draw the diagram, or create it in a program such as Draw.io. Please try to draw the diagram neatly. It may be helpful to create a rough draft, and then once you have the diagram finished, copy that to a clean piece of paper. Note: This description is written from the perspective of a guy who owns a pizzeria, not from the perspective of someone who knows about databases. You will have to do some interpretation to make this fit the Entity Relationship model. Some extra information may be included that will not be seen in our model
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
