Reference no: EM133860505

Question

Pizza Ordering System - Additional Requirements: The restaurant does not only offer pizza, but also other food items: Bread Sticks and Soda. A customer can order a food item. A Pizza can be veggie, meat lovers, cheese, or custom. This means that the pizza will have an attribute called type. The type can take any value in the value set {veggie, meat lovers, cheese, custom}. Notice that the ER diagram shows attributes but it does NOT show value sets of attributes. Value sets will be used later on when we create the database and populate it with data. So don't show the value sets on the diagram. A Bread Stick can be made of whole grain or regular flour. Again, try to identify attributes and their value sets. Attributes show on the diagram, value sets don't. A Soda can be coke, coke diet, or 7-up. Each type has a number of grams of sugar. For each bread stick or soda item that the customer orders, she has to specify the size and quantity.