Specify an identifier for each entity. Include these in the E-R diagram. Write your assumptions if any.
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.
Specify an identifier for each entity. Include these in the E-R diagram. Write your
assumptions if any.
Step by step
Solved in 3 steps with 1 images
