Data management-erd diagram definition

Assignment Help Basic Computer Science
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.

Reference no: EM13922525

Deadlock using updates on person

Cause a deadlock using updates on Person. Person and Human Resources. Employee. You will have to run different queries in sequence within two transactions using at least two

Sequential search question

Derive an exact formula in n (not big O) for the average number of target-to-element comparisons for successful searches on an array of size n, assuming that all possibilitie

Design and implement a graphical user interface (gui)

Design and implement a graphical user interface (GUI) that lets a user draw geometric objects such as rectangles, circles or line segments. The geometric objects are two be "e

Delegation and work allocation

Your manager has come to you to ask for assistance. Productivity levels of the team you supervise have been consistently dropping over the last three or four weeks. Your man

Given a scanner of double values

public double[] stats(Scanner scanner) Given a Scanner of double values, return an array of capacity three that has the maximum value in the Scanner as the value in result[0

Second order differential equation

Use the substitutions x1=x and x2=x' to rewrite the following second order differential equation as a first order system of differential equation in the variables x1, x2 and

Difficult or confusing for you to understand

You've probably noticed pop up ads that contain products or services similar to those for which you are shopping. HOW DO YOU FEEL ABOUT THIS? And is any of this content most

Calculate and display the volume of a cylinder

Write a complete program for Visual C++ to calculate and display the volume of a cylinder, given its radius and height. Your program must meet the following requirements.


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd