Notes to assist Q5
Note the following relationships:
- The main components are TEAM and GAME.
- Each team plays each other team at least twice.
- To play a game, two teams are necessary: the home team and the visitor team.
- Each team plays once as the home team and once as the visitor team.
Given these relationships, it becomes clear that TEAM participates in a recursive M:N relationship with GAME. The relationship between TEAM and GAME becomes clearer if we list some attributes for each of these entities:
Note: TEAM_NUM appears at least twice in a GAME:once as GAME_HOME_TEAM and once as GAME_VISIT_TEAM.