XYZ College could not be more pleased with your work. They have found so much efficiency, and solved for team conflict over data, that they have recommended you support the Hamilton Wentworth District School Boards dodgeball league. They would like you to design a tool to manage this commitment. In your ERD, please capture the following:

1. There is a set of teams, each team having an id, name, home arena, home school.
2. Each team has many players, and each player belongs to one team. Each player has a team registration number, full name, birth date, membership start year, and jersey number that they use.
3. The teams play games. For each game, there is a home team and an away team. The game takes place in the home arena of the home team.
4. For each game, we need to keep track of:
   1. The date on which the game is played
   2. The final result of the game
   3. The players participating in the game. For each player, how many players they eliminated, whether they were awarded a penalty (time-out or suspension).
   4. Any player substitutions, including the time the substitution took place.
5. Each game has two referees. Each referee has a license number, name, birthdate, and years of experience. One referee is the Referee of Record. The other is the assistant referee.

Question:

1.Create a Data Dictionary.

2. Design an ER diagram using Crows Foot technique.

3 State any assumptions that might influence your design.