Use the scenario below and design an entity relationship diagram with the following components.
- Identify the entities that need to be modeled
- Identify the attributes that each entity will include
- Identify the relationships as required.
- Identify the primary keys (identifier attributes)
- Identify any business rules or assumptions that are associated with your data model
Scenario:
Online Ordering and Delivery Service for Sandwich Shop Kelly's Sub Shop is starting an online ordering system that will provide local delivery within five miles of the sub shop. The customer can order a limited menu of the sandwiches the sub shop creates. The online order system will need to track the following information customer, order, and product. They shop will need to know the quantity ordered, toppings and other directions for the order. The delivery drive will need to know the address and phone number of the customer.