Online Ordering and Delivery Service for Sandwich Store Sandwich

Connect is starting an online ordering system that will provide local delivery within five miles of the sandwich shop. The customer can order a limited menu of the sandwiches the sandwich shop creates. The online system will need to track the following information customer, order and product. The store 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.

• 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)

Make sure you define the following:

1. Select database management system (Oracle) and identify the data types and sizes for all attributes.

2. Make sure all relationships have been addressed and corrected.

3. Review data model to make sure data model is in at least 3rd normal form (as defined by the normalization process).