Question: please answer the question indicated, in ER lucid chart diagram. please only answer if you're 100% sure. Thank you. Porcelli's Pies To better track costs

please answer the question indicated, in ER lucid chart diagram. please only answer if you're 100% sure. Thank you. please answer the question indicated, in ER lucid chart diagram. please only

Porcelli's Pies To better track costs of their pizzas, a small pizza business has asked you to create a database to track their menu- item pizza ingredients. The business currently sells pizza only, and includes three sizes, small at 12-inch diameter, medium at 14-inch, and large at 16-inch. Although customers can order pizzas with a variety of toppings, the different standard menu options are cheese, pepperoni, vegie, and meat-mania, and it is these standard menu items that the database is to track. The system needs to track which ingredients are on which standard menu item, and for each pizza size, record the owner's established amount of each topping in weight measured in grams. Ingredients include things like cheese, sauce, peperoni, sausage, ham, onions, green peppers, etc. The current per-gram cost of each ingredient needs to be recorded with the ingredient list. Some of the short-hand, abbreviation coding they currently use in the kitchen includes S. M. and L for small, medium, and large for sizes, and CH, PP, VG, and MM for cheese, pepperoni, vegle, and meat-mania respectively, but you may decide to use different codes in your database. Create an entity relationship diagram showing entities, cardinality, and needed attributes, including labeled primary and foreign keys

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!