Database Case 6: Squash Ladder


You are required to build a small database system to record details for a squash ladder. The ladder is divided into a number of divisions. Each division has a number of positions.

Each squash game has two players and one result. A result is made up of two scores, one for each participating player.

A player can play many games but only with players in the same division. A player can occupy only one position in the squash ladder at any one time. Players are ranked in positions in terms of their total scores.

The system should also record the name, address, telephone number and age of each player.


Last updated: April 2000

Return to Database Systems Page