Appendix A. The stores_demo Database

The stores_demo database contains a set of tables that describe an imaginary business. The examples in the IBM Informix: Guide to SQL Syntax, the IBM Informix: Guide to SQL Tutorial, and other IBM Informix manuals are based on this demonstration database. The stores_demo database uses the default (U.S. English) locale and is not ANSI compliant.

This appendix contains the following sections:

• The first section describes the structure of the tables in the stores_demo database. It identifies the primary key of each table, lists the name and data type of each column, and indicates whether the column has a default value or check constraint. Indexes on columns are also identified and classified as unique, allowing duplicate values.
• The second section (The stores_demo Database Map) shows a map of the tables in the stores_demo database and indicates the relationships among columns.
• The third section (Primary-Foreign Key Relationships) describes the primary-foreign key relationships among columns in tables.
• The final section (Data in the stores_demo Database) lists the data contained in each table of the stores_demo database.

For information on how to create and populate the stores_demo database, see the IBM Informix: DB–Access User's Guide. For information on how to design and implement a relational database, see the IBM Informix: Database Design and Implementation Guide.