Select one of the following 5 scenarios:
The entity relationship diagram is crucial to the creation of a successfully implemented application and database. A good understanding of how to identify the components that define the Entity Relationship Diagram is needed. Select one of the following 5 scenarios anddesign 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 1 – Online Ordering and Delivery Service for Sandwich ShopJoe’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.
Scenario 2 – A Local Football League You have been asked to develop a database to maintain details of the football teams signed up to play in a local league, including the schedule. The database must maintain details of the name and location of each team, and for each team the players (and their positions) who are on the team. So that a handicap system can be developed later the database should maintain the gender, and age of each player. Each player should also have one 'phone number stored. Schedule and field locations for each of the games the teams will play.