A database is being constructed to keep track of the teams and games of a football league:

*the league has many teams, each team has a name, a city, a coach, a captain, and a set of players.

*each player belongs to only one team, each player has an id, a name, a position (such as right back or center forward), a skill level, and a set of injury records.

* a team captain is also a player

* each injury record keeps track of the payer who has been treated, the date of the treatment, several drugs used in the treatment.

* a game is played between two teams (referred to as host_team and guest_team) and has a date (such as June 11th, 2015) and a score (such as 4 to 2).

Design an ER diagram for this application, stating any assumptions you make.

2) For your ER diagram given above, convert it into relational schema using the mapping guidelines discussed in the lecture. For each relation (table) obtained, specify the name and its attributes, as well as its primary key.