Create a semantic object model for a pizza order. The order will have a phone number...

Transcribed Image Text:

Create a semantic object model for a pizza order. The order will have a phone number which will uniquely identify it. It will also have an address to where the pizza is to be delivered (a group attribute). Finally, it will have one or more pizzas, another semantic object. Each pizza will have an order number that uniquely identifies it (distinct from the phone number of the order) and a size (small, medium, or large for example). In addition, each pizza will have a pepperoni attribute (no topping, one topping, double topping) as well as mushroom and sausage attributes (also no topping, one topping, double topping). Part 2. Draw an entity-relationship diagram to capture the above pizza order and pizza. Part 3. Convert either the above semantic object model or entity-relationship model into a relational model. Create a semantic object model for a pizza order. The order will have a phone number which will uniquely identify it. It will also have an address to where the pizza is to be delivered (a group attribute). Finally, it will have one or more pizzas, another semantic object. Each pizza will have an order number that uniquely identifies it (distinct from the phone number of the order) and a size (small, medium, or large for example). In addition, each pizza will have a pepperoni attribute (no topping, one topping, double topping) as well as mushroom and sausage attributes (also no topping, one topping, double topping). Part 2. Draw an entity-relationship diagram to capture the above pizza order and pizza. Part 3. Convert either the above semantic object model or entity-relationship model into a relational model.

Answer rating: 100% (QA)

The question youve presented is in multiple parts and revolves around the conceptualization and visualization of a database model for a pizza delivery ... View the full answer