1. Using the business case below in this assignment, complete the following requirements:

Business Case: Laval High School League (LHSL)

• The Laval high school league (LHSL) is a hockey league in Laval. Each neighborhood in the city has one team in this league that is named for that neighborhood. The city council plans to develop a database to help track players and their parents, coaches, and teams.
• Each team has a maximum of 9 and minimum of 6 players.
• It is not mandatory to have a player in the team, as long as the team is registered with the league.
• No player can join the league without being part of a team and cannot play for multiple teams.
• Each team can have a minimum of one and a maximum of 4 coaches, but a coach can only be assigned to one team.
• During the season, each team plays 2 games (home and visitor) against each of the other teams. The scores and wins/losses are tracked after each game by the teams.
• Each team has a number assigned to it automatically at the beginning of the league.
• It is important for the teams to follow the guidelines regarding the age of the players.
• In case of emergencies, teams are required to contact the parents of the players. Players will not be registered without contact information of at least one parent.

HINT: Many-to-many relationships must be split into two one-to-many relationships.

1. Draw the ERD of the database that could be used to support the operations of the business described in the case (7 marks).

The ERD should identify:

• Primary keys and Foreign keys;
• Entities and at least three Attributes for each entity;
• Relationships and Cardinalities (e.g. one-to-one, one-to-many).

Next to the ERD in your submission, list the assumptions made when designing the ERD. If an element of the business case does not provide the information necessary to know for certain whether one design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions.