Reference no: EM13922525
Data Management-ERD Diagram Definition
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 and design an entity relationship diagram with the following components:
- Identify the primary keys (identifier attributes)
- Identify any business rules or assumptions that are associated with your data model
- Identify the entities that need to be modeled
- Identify the attributes that each entity will include
- Identify the relationships as required.
Scenario 1 - Online Ordering and Delivery Service for Sandwich Shop Joe'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.
Scenario 3 - Student Internship Database
A local university is starting an internship program for its seniors to gain real world experience in local businesses to gain real-world experiences from the business word. The following information needs to be tracked, student, intern opportunity, company, degree program, application. The details related to the student is name, degree program, contact information. For the company need to track company name, address, contact information, Please identify any additional information that would be necessary to support the database design.
Scenario 4 - Children's Playgroup
A local community center is establishing a children's playgroup that will introduce children in the neighborhood to other parents and children. This playgroup will sponsor weekly play sessions with a structured activity and free play time each week. If this program is successful, the community center would like to offer this play session on a daily basis. The following information needs to be considered, a parent can have more than one child, the parent information, including name, phone number, and mailing address need to be tracking. Child's name, gender and age need to be tracked. The ability to track one or more sessions, including date, time, location and session type. Eventually the community center would like to add additional special "activities" that the parents and children would be interested.
Scenario 5 - Pet Sitting Service Company
A local company is starting that will provide pet sitting services for the local community. This company will provide in-house and daily pet sitting services for dogs, cats, fish, birds and reptiles. Each of their employees is insured and are certified pet care specialists. The company needs to track the following employee information, employee name, and address, pet types certified to support, hourly rate and availability. Information about the pet owner needs to be track, including pet owner name, address, billing information, and phone number. The pet information includes pet type, pet name, pet medications, pet likes and dislikes. The company needs to track the pet sitting requirements for each pet, including in-house or number of visits per day, total number of days for pet sitting order, special requirements for pet. In addition any special pet food, treats or information needs to be track about each pet. Each pet owner can have one or more pets.
|
Aspect of critical thinking by playing the believing game
: When looking for information about a particular issue, how often do you try to resist biases toward your own point of view? This assignment asks you to engage in this aspect of critical thinking by playing the "Believing Game.
|
|
Design uml and use case diagram
: You have access to the resources of the College. Officially enrolled students are automatically authorized to use the library resources. A College ID card will he required to use resources for both students and staff.
|
|
Variable costs associated with operating an automobile
: Short and Long Run. Let's assume that you own a fast food restaurant and you are faced with many customers each day eating in the restaurant without any tables. Describe the difference between the short run and long run in the example to bringing ..
|
|
How someone becomes afraid of heights
: You may describe, for example, how someone becomes afraid of heights, why a particular food or smell moves him or her emotionally, or why he or she dislikes elevators.
|
|
Data management-erd diagram definition
: 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 fol..
|
|
Which of these needs and expectations conflict
: How do the training needs and expectations of the workers and employers differ? Which of these needs and expectations conflict? Which converge?
|
|
What is the impact of a production bottleneck
: What is the impact of a production bottleneck? Explain how small lot sizes can reduce the impact of bottleneck operations.
|
|
Null hypothesis and alternate hypothesis
: The report will be structured as follows: Section: For each question provide: The null hypothesis, The alternate hypothesis, The test statistic chosen (including which test), The critical value and decision rule and The P-value
|
|
General environment of organizations
: Q.1. Identify at least four forces in the general environment of organizations and provide an example of each for an industry or business. How do these forces differ from the external stakeholders in the task environment?
|