Appendix A. DB2 Sample Tables

 <  Day Day Up  >  

This appendix provides information on the DB2 sample tables used in most of the figures and examples in this book. These tables are used as examples in this book as a convenience because they are bundled with DB2, installed at most DB2 shops , and are generally available for everyone's use.

An understanding of the data in the sample tables and the relationship between these tables is imperative to understanding the SQL in this book. The DB2 sample tables primarily contain information about projects and the entities involved in working on these projects. Figure A.1 shows these entities and the relationships between them.

Figure A.1. DB2 sample table relationships.

graphics/ap01fig01.gif


The sample tables represent departments, employees, projects, activities, activities assigned to a project, and employees assigned to a project's activities. In the following sections, you can find a general description of each table, its columns , and its relationship to the other sample tables, along with its table creation DDL.

 <  Day Day Up  >  


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net