Diagram of the pubs2 database  Tables in the pubs3 database


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.





Copyright © 2005. Sybase Inc. All rights reserved. Tables in the pubs3 database

View this book as PDF