O'Reilly logo

Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition by Rick F. van der Lans

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required