Fall Semester 2002

• Player One
• Player Two
• Player Three
• Player Four
• Player Five
• Player Six

• Wimbledon (UK)
• Rolland Garros (France)
• US Open (US)

A dash (-) in the table above means no money (NULL).

Please accomplish the following tasks:

Part One (40 points)

• Design a database (call it Practical) to hold the data for such a circumstance (tables, columns, keys), then populate your tables with the data above.

  Note: your structure should not have to change when we add a player or a tournament.

Create the following queries:

• List players with a total of at least $100,000 in winnings thus far.

• List all the players sorted by their average wins (amount divided by no. of tourneys).

• List all players that have won some amount in some tourney.

Part Three (10 points)

Create a form entitled Players by Tournaments which contains

• for every tournament information about the tournament and

• a subform that contains
  1. (only) the players that have won money in that tournament,

  2. with the respective wins (amounts).

Part Four (10 points)

Create a report in which you list the players. For each player

• the report should include all the amounts the player has won,

• (each amount listed next to the name of the tournament)

• together with the overall average win for that player.

Challenge (10 points)

• List those players that did not win anything anywhere.

Please make sure your database fits on a floppy disk.

Also,

• turn the disk in at the end of the exam to your lab coordinator, and

• make sure the disk is readable before you turn it in.