Hoosier 5

 

Hoosier Burger Case: Part 5
Read the Hoosier Burger scenario on page 242 in Chapter 7 of the text and address the following in a 1 to 3 page APA style paper:       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 an identifier 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 cardinalities for each relationship.

 

Hoosier Burger

Although Hoosier Burger is well recognized for its fast foods, especially the Hoosier Burger Special, plate lunches are also offered. 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 combination 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 customers to charge their order. Once each month, a bill is generated and sent to those business customers 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 to track a customer’s 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 an identifier 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 cardinalities for each relationship.

(Valacich 242)

Valacich, George, & Hoffer. Essentials of System Analysis and Design, 4th Edition. Pearson Learning Solutions. .

FIGURE 7-10 Preliminary E-R Diagram for Hoosier Burger’s Inventory Control System

The wording in the previous description tells us much of what we need to know to determine relationships:

■ An INVOICE includes one or more INVOICE ITEMs, each of which corresponds to an INVENTORY ITEM. Obviously, an INVOICE ITEM cannot exist without an associated INVOICE, and over time the result will be zero-to-many receipts, or INVOICE ITEMs, for an INVENTORY ITEM.

■ Each PRODUCT is associated with INVENTORY ITEMs.

■ A SALE indicates that Hoosier sells one or more ITEM SALEs, each of which corresponds to a PRODUCT. An ITEM SALE cannot exist without an associated SALE, and over time the result will be zero-to-many ITEM SALEs for a PRODUCT.

Figure 7-10 shows an E-R diagram with the entities and relationships previously described. We include on this diagram two labels for each relationship, one to be read in either relationship direction (e.g., an INVOICE Includes one-to-many INVOICE ITEMs, and an INVOICE ITEM Is_included_on exactly one INVOICE). Now that we understand the entities and relationships, we must decide which data elements are associated with the entities and associative entities in this diagram.

(Valacich 223)

Valacich, George, & Hoffer. Essentials of System Analysis and Design, 4th Edition. Pearson Learning Solutions. .