Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please identify the requirements (Actors, roles) for this entity-relationship diagram IN WORDS. For example: Team - Each team has players Player - no player belongs

Please identify the requirements (Actors, roles) for this entity-relationship diagram IN WORDS. For example: Team - Each team has players

Player - no player belongs to more than one team

Team - A team can't have no players.

The Youth Soccer League ERD The soccer league consists of teams, each of which has a unique team name. Each team has one or more sponsors whose names appear on the team uniforms. Each team consists of a number of players. No player belongs to more than one team. Each player is assigned a unique Player ID when they join the league. The league records each players name (first name and last name) and phone number. In order to verify players ages, the league records each players date of birth. One player on each team is designated as team captain. Teams play each other in matches. Each match is given a unique Match ID number and is scheduled for a specific date. Each match is between two teams. The league records the score of each match. In addition, the league records, for each match, the number of minutes played by each player, as well as the number of goals scored by each player, and also the number of penalties assessed against each player. It is possible for a player to not participate in any matches. A parent volunteers serve as referees for the matches. The league assigns three referees to each match, one head referee and two linesmen. For each match, the individuals serving in each position are recorded. All of the referees are assigned a unique Referee ID number when they first register with the league. The league records each referees name (first name and last name) and phone number. Each new referee is assigned to one experienced referee as a mentor. Not all of the experienced referees serve as mentors, but those that do can mentor more than one new referee. Matches take place at soccer fields. Each field has a unique name. The league records the name and address (street, city, state, and zip) of all the fields where it stages matches. Each match, occurs at a single field at a time. The fields host multiple matches Some fields are closed when undergoing renovations with no matches scheduled. Each field is associated with food and beverage vendors. Vendors sell refreshments at the soccer matches. Vendors are assigned to matches at specific fields. Each field has several vendors servicing it, but each vendor services only one field. Each vendor has a unique name. In addition to the vendors name, the league records the vendor phone number and the vendor type (cooked foods, packaged snacks, beverages, etc.). Some vendors serve multiple types of food and beverage.

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

PC Magazine Guide To Client Server Databases

Authors: Joe Salemi

1st Edition

156276070X, 978-1562760700

More Books

Students also viewed these Databases questions

Question

6. Identify seven types of hidden histories.

Answered: 1 week ago

Question

What is the relationship between humans and nature?

Answered: 1 week ago