Question

Using the Erwin Software (or draw.io) to construct a logical data model using the IE notation to fit the following circumstances. The Metro Hockey Association is made up of several leagues. A league has a unique name and a level. A hockey league will each contain at least four hockey teams. Each hockey team has a unique name and a location and is composed of six to twelve players, and one player captains the team. Players have a team number within their team and a position. Players can only be registered on one team. Hockey teams play games against each other on specified dates. Teams may meet more than once a season. Each game has a score and a result. Teams have at least one coach and sometimes several coaches. Each coach has a unique id and a level of accreditation and a number of years of experience and can coach multiple teams. A coach will have a role title for each team they coach. On any one team a coach may supervise other coaches. Coaches and players have names and addresses.

Answer 1

A logical data model for the Metro Hockey Association using IE notation includes entities such as leagues, teams, players, coaches, and games, with attributes and relationships that capture the associations between them, such as leagues containing teams, players belonging to teams, and coaches coaching multiple teams.

Step-by-step explanation:

Logical Data Model for Metro Hockey Association

Constructing a logical data model for the described Metro Hockey Association using IE notation involves identifying entities, attributes, and relationships. The entities can be identified as leagues, teams, players, coaches, and games, while the relationships would involve associations such as teams belonging to leagues, players belonging to teams, and coaches coaching teams.

• League(LeagueName, Level)
• Team(TeamName, Location, LeagueName)
• Player(TeamNumber, Position, TeamName, isCaptain, Name, Address)
• Coach(CoachID, AccreditationLevel, YearsExperience, Name, Address)
• Game(GameDate, TeamName_Home, TeamName_Away, Score, Result)
• Team_Coach(TeamName, CoachID, RoleTitle, Supervises)

The League entity has a unique name and a level attribute. Each Team, associated with a League, has a unique name and location. Players are uniquely identified by a team number within their team, have an attribute for position, and one player is assigned as the captain (isCaptain attribute).

Each game is identified by the playing date and the participating teams. The Team_Coach entity represents the many-to-many relationship between coaches and teams, with an additional attribute for the RoleTitle a coach holds in a team and potentially a reflexive relationship indicating supervision of coaches.