As a data architect, you are supposed to design database for local soccer league. The

requirements for database design are given in the following:

$[$Hint$]$ A capital word represents an Entity, a word with italic font is an attribute.

The soccer league consists of nearly two dozen TEAMs, each of which has a unique team name $($e$.$g$.,$

Flyers, Strikers, etc.$).$ Each team has one or more $\{$sponsors$\}$ whose names appear on the team uniforms.

The name, address, and a phone number are stored in database for each sponsor. Each team has a head

coach $($name$)$ and address. Each team has a number of PLAYERs. No player belongs to more than one

team. Each player is assigned a unique PlayerID when they join the league. The league also records each

player$$s name $($first name and last name$),$ phone number, and date of birth. One player on each team is

designated as that team$$s captain.

Teams play one another in a series of scheduled MATCHes. Each match is given a unique MatchID

number and is scheduled for a specific date. Each match is between two teams. All teams play a season

schedule consisting of twenty matches. The league records the $($SCORE$)$ of each match. In addition, the

league records minutes played by each player in each match, as well as any points scored $($e$.$g$.,$ through

goals or assists$)$ by individual players and also any penalties assessed against individual players. Due to

injuries or other reasons, not all rostered players actually get to participate in matches.

A group of 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 referees serve at several matches over the course of a season. All of the volunteer

referees are assigned a unique RefereeID number when they first register with the league. In addition, the

league records each referee$$s name $($first name and last name$)$ and phone number. In addition, each new

referee is assigned to one experienced referee for training purposes. Not all of the experienced referees

serve as trainers, but those that do often train more than one new referee.

Matches take place at soccer FIELDs located throughout town. Each field has a unique name. The league

also records the street address of all the fields where it stages matches. Each match, of course, occurs at a

single field. The fields are typically used for multiple matches, but a couple of fields are currently

undergoing renovations and no matches are scheduled for them.

Each field has associated with it several food and beverage VENDORs. These vendors sell refreshments

to spectators at the soccer matches. To share business fairly, the league has awarded $$franchise$$ rights to

the matches at specific fields to specific vendors. Thus, although each field has several vendors servicing

it$,$ no vendor serves more than one field. Each vendor has a unique name. In addition to the vendor$$s

name, the league records the vendor phone number and the vendor type $($e$.$g$.,$ cooked foods, packaged

snacks, beverages, etc.$).$ Some vendors are specified with multiple types.