Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Summarizing the bookbiz Database

Let's take a closer look at the nine tables in the bookbiz database to better familiarize you with the material on which the examples in the rest of The Practical SQL Handbook are based. (There are more bookbiz details in Appendix D.)

The bookbiz database keeps track of the activities of three subsidiary publishing companies. Since the fiscal arrangements of the subsidiaries are not independent, the parent publisher has chosen to maintain a single database.

The publishers table contains information about the three publishing lines: their identification numbers, names, and addresses.

For each author under contract with any of the publishers, the authors table contains an identification number (Social Security number), ...