The pubs3 Database

This chapter describes the sample database pubs3. This database contains the tables publishers, authors, titles, titleauthor, salesdetail, sales, stores, store_employees, discounts, roysched, and blurbs.

The pubs3 database also contains

primary and foreign keys, rules, defaults, views, triggers, and stored procedures.

A diagram of the pubs3 database appears in Figure B-1.

For information about installing pubs3, see the configuration guide for your platform.

Tables in the pubs3 database

publishers table

authors table

titles table

titleauthor table

salesdetail table

sales table

stores table

store_employees table

roysched table

discounts table

blurbs table

Diagram of the pubs3 database


	Expand Search