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, meatloaf, 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 five, ten, fifteen, or twenty individuals. As a convenience to its business customers, Bob and Thelma allow business customers to charge their orders. 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 4Hoosier Mighty Meals. Bob asks you if it is possible to track a customer’s order history, and you indicate that it is indeed possible. Order management includes creating and deleting orders, adding and removing items from an order, and closing orders. Orders should also be stored in the database to be used to calculate total sales. Menu items must be added, edited, and deleted from the menu item database. Items that can be ordered must be able to be added and removed from an order. Orders should also be stored in the database to be used to calculate total sales Q.3. Based on the information provided in the case scenario, what entities will Hoosier Burger need to store information about? Be sure to specify the relationships between the entities and the cardinalities for each relationship. Draw an E-R diagram. Write your assumptions if any.Q.4. For the entities identified, identify a set of attributes for each entity. Include these in the E-R diagram. Write your assumptions if any.Q.5. Specify an identifier for each entity. Include these in the E-R diagram. Write your assumptions if any. (All parts of one question)
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, meatloaf, 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 five, ten,
fifteen, or twenty individuals. As a convenience to its business customers, Bob and Thelma
allow business customers to charge their orders. 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
4
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. Order management includes creating and deleting orders,
adding and removing items from an order, and closing orders. Orders should also be stored in
the
deleted from the menu item database. Items that can be ordered must be able to be added and
removed from an order. Orders should also be stored in the database to be used to calculate
total sales
Q.3. Based on the information provided in the case scenario, what entities will Hoosier Burger
need to store information about? Be sure to specify the relationships between the entities
and the cardinalities for each relationship. Draw an E-R diagram. Write your assumptions if
any.
Q.4. For the entities identified, identify a set of attributes for each entity. Include these in the
E-R diagram. Write your assumptions if any.
Q.5. Specify an identifier for each entity. Include these in the E-R diagram. Write your
assumptions if any.
(All parts of one question)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
