Consider a Hockey Game. A Game is really nothing more than a relationship between two Hockey Teams. For Example, the New York Rangers play the Buffalo Sabres many times in a season. Sometimes, The New York Rangers are the HomeTeam, and sometimes they are the VisitingTeam. For each game played, we need to keep track of who is the HomeTeam, who is the VisitingTeam, When they played (i.e., the DatePlayed), What the HomeTeamScore was, and What the VisitingTeamScore was. Each Team is identified by a TeamID. We need to also keep track of each TeamName, and other information. Each team also employs a number of players. Each player is identified by a PlayerID. We also keep track of each PlayerName, as well as other information. Unfortunately (for this problem), a player can play for a number of different teams during their careers. As a matter of fact, a player might play for one team, be traded to another, and then later be traded back to the team they played for previously. We must therefore also keep track of when a player started playing for a particular team, and when they stopped playing for a particular team (if they are still playing for a team, the value NULL is placed in the date they stopped playing for a particular team).

 

Draw the necessary ERD to reflect this situation.

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Note:  * indicates Primary Keys; ** indicates Primary and Foreign Keys