Cincinnati Adult Soccer League $($CASL$)$ is a hypothetical adult$-$based outdoor soccer league based in Cincinnati, OH$.$ The league boasts of $12$ current teams, each with at least $11$ 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 $($e$.$g$.,$ 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 $18$ years of age to be accepted in the league. One player on each team is assigned as the captain.

Matches are $90$ 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 $15$ 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 $2)$ before the match, and ensures that stats are tracked for each match and for each player. Some of the most$-$commonly 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 $3$ goals and $2$ 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 sponsor$$s name. CASL allows companies to sponsor more than team $($e$.$g$.,$ 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 $1)$ with the match score and winner filled in after the match concludes.

The league director has been keeping data in text$-$based documents $($e$.$g$.,$ 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:

$1.$ Write out the relational schema for all the data. It may be helpful for you to include determinants using functional dependencies for each attribute.

$2.$ Normalize to $3$NF$.$

a$.$ Normalize to $1$NF$.$ Show your work.

b$.$ Normalize to $2$NF$.$ Show your work.

c$.$ Normalize to $3$NF$.$ Names are usually not appropriate for Pks$,$ so add a code, if needed. Assign foreign keys, as appropriate.

d$.$

$3.$ 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 $2$: Sample Rosters for $3/5/2024$ CNorth$-33$pm Match