Home | Previous Page | Next Page  

Appendix B. The sales_demo and superstores_demo Databases

The sales_demo Database (XPS)
Dimensional Model of the sales_demo Database
Structure of the sales_demo Tables
The customer Table
The geography Table
The product Table
The sales Table
The time Table
The superstores_demo Database (IDS)
Structure of the superstores_demo Tables
The call_type Table
The catalog Table
The cust_calls Table
The customer, retail_customer, and whlsale_customer Tables
The items Table
The location, location_non_us, and location_us Tables
The location Table
The location_non_us Table
The location_us Table
The manufact Table
The orders Table
The region Table
The sales_rep Table
The state Table
The stock Table
The stock_discount Table
The units Table
User-Defined Routines and Extended Data Types
location_t definition
loc_us_t definition
loc_non_us_t definition
name_t definition
customer_t definition
retail_t definition
whlsale_t definition
ship_t definition
Table Hierarchies
Referential Relationships
The customer and orders Tables
The orders and items Tables
The items and stock Tables
The stock and catalog Tables
The stock and manufact Tables
The cust_calls and customer Tables
The call_type and cust_calls Tables
The state and customer Tables
The customer and location Tables
The manufact and location Tables
The state and location_us Tables
The sales_rep and region Tables
The region and location Tables
The stock and stock_discount Tables
The stock and units Tables

In addition to the stores_demo database that is described in detail in Appendix A. The stores_demo Database, IBM Informix products include the following demonstration databases:

This appendix discusses the structures of these two demonstration databases.

For information on how to create and populate the demonstration databases, including relevant SQL files, see the IBM Informix: DB–Access User's Guide. For conceptual information about demonstration databases, see the IBM Informix: Database Design and Implementation Guide.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]