Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Youth Soccer League: Entities, Attributes, Relationships The soccer league administrator wants to create a database to track teams, players, coaches, matches, fields, vendors, referees,
The Youth Soccer League: Entities, Attributes, Relationships
The soccer league administrator wants to create a database to track teams, players, coaches, matches, fields, vendors, referees, and sponsors.
Reports include; match scores and results, player stats, referee assignments, team rosters, field and team sponsors, vendor types and field assignments, and coach assignments.
The soccer league consists of teams. Teams have one or more sponsors whose names appear on the team uniforms. Sponsors can support more than one team, and a team may have more than one sponsor at a time. Sponsorships are tracked by season.
Each team consists of players. No player belongs to more than one team during a single season. Each player is assigned a unique Player ID when they join the league. The league records each players name and address, parent contact name, player phone number and parent phone number, and parent email. In order to verify players ages, the league also records each players date of birth. Each team has a designated captain from among the players. Players are registered for the league followed by a draft to receive their team assignments. Players can play for one team one season and then play for a different team the next season.
Teams play in matches. Each match is given a unique Match ID number and is scheduled for a specific date. The league records the goals scored by each team and the win or loss result.
Player performance in each match is recorded for minutes played, goals scored, and penalties assessed. It is possible for a player to not participate in a match.
The league assigns three referees to each match, based on position one head H and two linesmen L 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 address and phone number, and contact email. 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. Sponsors can support fields by placing banners. Sponsors can support more than one field, and fields can have more than one banner. 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 throughout the season. Some fields are closed when undergoing renovations with no matches scheduled during that period.
Vendors sell items at specific fields. Each field has several vendors. The league tracks the vendor assignments by season. In addition to the vendors name, the league records the vendor phone number and the vendor type. Some vendors offer multiple types of services, for example: food, beverage, clothing, soccer suppliers, and other items.
The league also tracks coaches. A coach can be assigned to more than one team, but only as one role per assignment. Coaching roles are head HC assistant AC volunteer VC Each team can have multiple coaches, but only one role at a time may be assigned to a single coach. Coach assignments are based upon season.
Reports
League administrator wants to run the following reports:
Team Rosters player full name and age calculated from DOB.
Game Report teams, goals scored, winloss head coach, head ref, date, match number.
Player Performance play full name, total minutes played, penalties, goals, games.
Team Report team name, games played, goals for and goals against, differential, winloss record.
Rosters
The league wants to be able to track rosters for each season. You need to figure out how to design the relationship between players and teams to support the tracking of playerteam assignments based on season.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started