Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cincinnati Adult Soccer League ( CASL ) is a hypothetical adult - based outdoor soccer league based in Cincinnati, OH . The league boasts of
Cincinnati Adult Soccer League CASL is a hypothetical adultbased outdoor soccer league based in Cincinnati, OH The league boasts of current teams, each with at least players, playing a spring and fall season each year.
Each team is coached by one head coach and one assistant coach optional and sponsored by one local company. A coach is assigned to one team only. Coaches are usually selected on a volunteer basis and enrolled each season with their full name, age, and gender eg Fred Lasso is the Head coach the Ranchers, while the Assistant coach is Red Beard
Players enroll in the league in the spring of each year and are assigned to play on one team. Each player on a team is assigned a jersey with a unique number. Players must include their full name, age, and gender when they enroll. Players must be at least years of age to be accepted in the league. One player on each team is assigned as the captain.
Matches are minutes in length and are played between two teams on one field of a park under the control of a referee ref If the match ends in a tie, the teams will play two extra times of minutes or go directly to penalty kicks so that a match winner is established. Teams play matches on a field of a Cincinnati soccer park. Most of the soccer parks house several fields, and a field can host several matches.
Typical positions on a team include a Goalkeeper, Forwards Striker Center Forward, Wingers Midfielders Mid Right Mid, Center Mid, Attacking Mid, Defensive Mid and Defenders Center back, Left Back, Right Back, and Wing Backs The coach picks a captain for each team, decides the roster which players play which positions, Figure before the match, and ensures that stats are tracked for each match and for each player. Some of the mostcommonly tracked stats include match score, goals, assists, possession pass counts, and passing chains. For example, in the first match of the season, Denise Stacker had goals and assists.
Sponsor company names and addresses are tracked, as well as the email of the main contact at the sponsor company. Teams wear jerseys sporting the sponsors name. CASL allows companies to sponsor more than team eg First Union Bank sponsors both the Ranchers and Manchester teams
The league director plans the season schedule for all the teams. A match schedule for the day could look like the following Figure with the match score and winner filled in after the match concludes.
The league director has been keeping data in textbased documents eg MS Word or Google Sheets but is finding it increasingly difficult to get insights from the data. Thus, the league has decided to build a database to support its operations.
A Instructions:
Design the solution:
Write out the relational schema for all the data. It may be helpful for you to include determinants using functional dependencies for each attribute.
Normalize to NF
a Normalize to NF Show your work.
b Normalize to NF Show your work.
c Normalize to NF Names are usually not appropriate for Pks so add a code, if needed. Assign foreign keys, as appropriate.
d
Sketch an EER on paper or your favorite drawing tool to show your final design model for the database, including all entities, attributes, and relationships.Figure : Sample Rosters for CNorthpm Match
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