This chapter describes a database that a tennis club could use to record its players’ progress in a competition. Most of the examples and exercises in this book are based on this database, so you should study it carefully.
The tennis club was founded in 1970. From the beginning, some administrative data was stored in a database. This database consists of the following tables:
PLAYERS table contains data about players who are members of the club, such as names, addresses, and dates of birth. Players can join the club only at the first of January of a year. Players cannot join the club in the middle of the year.