Appendix B: The pubs3 Database

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

It lists the primary primary and foreign keys, rules, defaults, views, triggers, and stored procedures used to create each table.

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

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