A database is to be constructed to keep track of the teams and games of a sport league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game of each team and the result of the game.
Create an ER diagram, completely with attributes, keys and constraints, for the above description. State any assumptions that you make.