This is a problem to be solved regarding database. There is a set of teams, each team has an id, name, home arena, home school. 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. 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.

d) For each game, we need to keep track of: a. The date on which the game is played b. The final result of the game c. The players participating in the game. For each player, how many players they eliminated, whether they were awarded a penalty (time-out or suspension). d. Any player substitutions, including the time the substitution took place. e) 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.

Create a Data Dictionary. Design an ER diagram. State any assumptions that might influence your design.