Bob and Thelma think a customer-food tracking system for the evening delivery service will offer additional information about their customers. One afternoon Bob and Thelma stop by your desk and assign you the task of preparing entity-relationship diagrams for the system. Your review of these deliverables suggests that the customer-food tracking system’s primary objective is to track and forecast customers’ food ordering patterns in the evening delivery service. Additionally, to track a customer’s ordering habits, an order history must be established, satisfaction levels assessed, and a variety of demographic data collected. The demographic data will categorize the customer according to customer type (business or home), geographic location, etc. The customer-food tracking system should be able to generate a report on customer information, menus, the price of each menu, and the total sales amount of each order. The customer-food tracking system information will enable Hoosier Burger to better forecast its food order, manage its inventory, and promote specific food to customers. 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.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Related questions

Concept explainers

Question

Bob and Thelma think a customer-food tracking system for the evening delivery service will offer additional information about their customers. One afternoon Bob and Thelma stop by your desk and assign you the task of preparing entity-relationship diagrams for the system. Your review of these deliverables suggests that the customer-food tracking system’s primary objective is to track and forecast customers’ food ordering patterns in the evening delivery service. Additionally, to track a customer’s ordering habits, an order history must be established, satisfaction levels assessed, and a variety of demographic data collected. The demographic data will categorize the customer according to customer type (business or home), geographic location, etc. The customer-food tracking system should be able to generate a report on customer information, menus, the price of each menu, and the total sales amount of each order. The customer-food tracking system information will enable Hoosier Burger to better forecast its food order, manage its inventory, and promote specific food to customers. 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.

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions