Create an Entity Relational diagram for the football league games and transform the schema into tables.

The baseball league comprises of many teams

Each team has a name, city, and a team of players, coach and a captain.

Each team can play with each other multiple times.

Each player can play only for one team. (there are no trades/changes)

Each player has a name, skill level, record of number of wins, total number of games played.

A team captain also plays for the team.

A game is played between the two teams.

A game results in win/loss or a touchdown.