Assignment 2

The first three exercises are from the text.

1. Exercise 2.2, p 52

2. Exercise 2.6, pp 53-54

3. Exercise 2.8, pp 55

4. A database is being constructed to keep track of the teams and games of a sports 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 for each team, the positions they played in that game, and the result of that game. Try to design an ER diagram for this application, stating any assumptions you make. Choose your favorite sport (soccer, football, baseball, etc.)