Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help doing c and d 2. Hoosier Burger Although Hoosier Burger is well recognized for its fast foods, especially the Hoosier Burger Spe-

I need help doing c and d

image text in transcribed

image text in transcribed

2. Hoosier Burger Although Hoosier Burger is well recognized for its fast foods, especially the Hoosier Burger Spe- cial, plate lunches are alsooffered. These include such main menu items as barbecue ribs, grilled steak, meat loaf, and grilled chicken breast. The customer can choose from a variety of side items, including roasted garlic mashed potatoes, twice baked potatoes, coleslaw, corn, baked beans, and Caesar salad. Many downtown businesses often call and place orders for Hoosier Mighty Meals. These are com bination meals consisting of a selection of main menu items and three side orders. The customer can request Hoosier Mighty Meals to feed 5, 10, 15, or 20 individuals. As a convenience to its business customers, Bob and Thelma allow business cus- tomers to charge their order. Once each month, a bill is generated and sent to those business cus- tomers who have charged their orders. Bob and Thelma have found that many of their business customers are repeat customers and often place orders for the same Hoosier Mighty Meals. Bob asks you if it is possible totrack acustomers order history, and you indicate that it is indeed possible. a. Based on the information provided in the case scenario, what entities will Hoosier Burger need to store information about? b. For the entities identified in part a, identify a set of attributes for each entity. c. Specify anidentifier for each entity. What rules did you apply when selecting the identifier? d. Modify Figure 7-10 to reflect the addition of these new entities. Be sure to specify the car dinalities for each relationship

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What are the two types of actions you can take to protect yourself?

Answered: 1 week ago

Question

Describe the basic features of an access control list.

Answered: 1 week ago

Question

2. To compare the costs of alternative training programs.

Answered: 1 week ago

Question

1. The evaluation results can be used to change the program.

Answered: 1 week ago