Exercise: Pizza Shop You are designing a database for a pizza shop that wants to

Question

Exercise: Pizza Shop

You are designing a database for a pizza shop that wants to get into Web-based sales. Your client has given you the transcript of a typical phone order conversation:

Pizza shop associate (Lori): Thank you for calling the Pizza Shop; this is Lori. How may I help you?

Caller (Rick): What toppings do you put on your all-meat special?

Lori: Italian sausage, pepperoni, ground beef, salami, and bacon.

Rick: OK, I'd like a large one, but without the bacon.

Lori: Do you want regular crust, extra-thin, or whole wheat?

Rick: Regular is fine. And a medium wheat crust with just cheese.

Lori: We have mozzarella, parmesan, romano, smoked cheddar, and jalapeno jack.

Rick: Uhhh just mozzarella and romano. What kind of sauce is on that?

Lori: Marinara, spicy southwestern, tandoori masala, or pestoyour choice.

Rick: Pesto sounds good.

Lori: You can add a large order of breadsticks for just 99 cents.

Rick: Sure, why not? And I'd like three small salads (muffled) make two of'em with Italian dressing and one with ranch.

Lori: The dressing comes on the side; we'll give you an extra one of each flavor. What would you like to drink?

Rick: Keg'a beer, maybe?

Lori: Sorry, we just have soft drinks.

Rick: (laughs) Just kidding how about two medium diet colas and a large iced tea.

Lori: That's one large regular crust all-meat special, no bacon, one medium wheat crust with pesto sauce, mozzarella and romano, one large order of breadsticks, three small salads, three Italian dressing, two ranch, two medium diet colas and one large iced tea. Just a minute, please (cash register clicks several times) your total with tax is 27 dollars and 39 cents. Is this for pickup or delivery?

Rick: I'll pick it up.

Lori: And your name?

Rick: Rick.

Lori: Thank you for your order, Rick. It'll be ready in about 20 minutes.

Rick: See'ya then.

*Develop a list of the enumerated attributes that are discussed in this conversation.

Explanation / Answer

TOPPINGS { Italian sausage, pepperoni, ground beef, salami, and bacon }

BASE TYPE { regular crust, extra-thin, or whole wheat }

CHEESE TYPE { mozzarella, parmesan, romano, smoked cheddar, and jalapeno jack }

SAUSE TYPE { Marinara, spicy southwestern, tandoori masala, pestoyour }

SOFT DRINKS { COLAS , ICE TEA , BEER }

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.