Question $1($Advance ERDs$)(25$pts$)$

Create the ERD for the Following:

Requirements Analysis

The Eagle Ridge Soccer League needs a database system to help track kids that sign up to play soccer. The

business rules are defined as follows:

Part $1$

Part $2$

Players register two months prior to the start of the season where they receive a registration number,

registration date, and assigned a unique player id$.$ In addition, the league stores first and last names, birth

date, and shirt number for each player. Shirt numbers are not assigned until the first practice. Each player

can only play for one team, but they are not assigned to a team until all players have registered.

The number of teams in the league for the current year is determined by the number of players registered.

Each team is identified by team number and team name. Each team has at least $12$ players.

Each team is supported by a sponsor with each sponsor supporting only one team. Each team is assigned a

sponsor when the teams are identified. The team's name is the sponsor's name. Each sponsor is given a

unique id and sponsor name, and contact person are stored for each sponsor. Sponsors are maintained in

the database even if they are not sponsoring a team in the current season.

When registering, players specify the positions they wish to play. Each position is identified by position

number and position name. Players indicate their preference $(1,2,3,$ and so on$)$ of their preferred positions.

Each player may have several guardians. Moreover, each guardian may be responsible for several players.

Guardians are assigned a unique id and first and last names are stored.

At the first practice, each team selects a team captain from the players.

Each coach is assigned to one team. However, each team may have up to three coaches. Each coach has a

unique id and first and last names, years coaching, and coaching certificate number are stored.

Usually, teams do not have more than three colors, but the league does not want to restrict a team from

having more than three colors.

Name the diagram Q$1$P$1.$

Draw the ER diagram using IE notation including any many$-$to$-$many relationships.

Name the Digram Q$1$P$2.$

Draw the ER diagram using IE notation resolving the many$-$to$-$many relationships.