Chapter 2. The Tennis Club Sample Database

Introduction

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.

Description of the Tennis Club

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

  • TEAMS

  • MATCHES

  • PENALTIES

  • COMMITTEE_MEMBERS

The 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.

The ...

Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial