Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need an ER Diagram created based on the below criteria modeled in SQL. Use the following business rules to create a single Entity-Relationship Model using

Need an ER Diagram created based on the below criteria modeled in SQL.

image text in transcribed

Use the following business rules to create a single Entity-Relationship Model using the SQL Data Modeler software. Show all appropriate relationships and cardinalities in the diagram. You do not need to resolve any many-to-many relationships for this question, and you need not include primary keys unless specified. A local youth league needs a database system to help track the children (players) who sign up to play soccer. Data needs to be kept for each team and the children who are playing on the team. Information for the parents must also be stored for each child. Information for each coach assigned to each team must also be available, including the date that a background check was completed for the coach. In addition, game schedules for the teams must be stored. Use the following rules when developing your ER-diagram: A team may have zero or more players assigned to it, and a player may be assigned to a single team A team must have one or more coaches assigned to it, and a coach must be assigned to only one team. A parent must have 1 or more player in the league and a player must have one or more parent. d.) Each team may compete in many matches, and each match is between two teams e. Each match will be assigned to a single field, but each field will have many matches assigned to it. f.) Additional data requirements: For each player, track the player's first and last names, address, phone number and age. For each parent, track the parent's first and last names, address, and phone number. For each coach, track the coach's first and last names, address, phone number, and date of background check. For each match, track the date of the match, the time of the match and the field number (a foreign key to the Field). For each field, track the field name, field number and field city. Each team has a name and an attribute to store the maximum number of players allowed on the team. You should have entities, attributes and relationships in your model. Include the verb phrases for each relationship but you do not need to include data types or domains for the attributes. You do not need to include primary keys if they are not defined in the business rules. You do not need to distinguish between Identifying and Non-Identifying relationships for this model

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

4th Edition

0805360476, 978-0805360479

More Books

Students also viewed these Databases questions

Question

Video Case: Satisfying Customers at Flight 001

Answered: 1 week ago