© Clare Churcher 2016

Clare Churcher, Beginning SQL Queries, 10.1007/978-1-4842-1955-3_13

1. Example Database

Clare Churcher

(1)Studio B Productions, Great Neck, New York, USA

Most of the examples in this book use the golf club database. Visit the catalog page for this book on the Apress website, look under the Source Code/Downloads tab, and you will find an Access version of this database and also the SQL scripts for creating and populating the tables. Figure A1-1 shows how the tables in the database are related, and Figure A1-2 shows the data in the tables.

A158240_2_En_13_Fig1_HTML.jpg
Figure A1-1. The data model for the golf club database
Figure A1-2. The tables and data for ...

Get Beginning SQL Queries: From Novice to Professional, Second 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.