TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

46 Chapter2
Database Structure and Protection
Data Set Types and Relationships
The ORDERS Database
Figures 2-5 and 2-6 illustrate the complete ORDERS database. Figure 2-5. lists the data
items within each data set as defined in the schematic of the ORDERS database shown in
Figure 2-2. The data types (in parentheses) are described in chapter 3 with the item part of
the schema. Paths are indicated by arrows. CUSTOMER, SUP-MASTER, PRODUCT, and
DATE-MASTER are master data sets and SALES and INVENTORY are detail data sets.
Figure 2-6. shows a sample entry from each data set and two sample entries for
DATE-MASTER.
Chains of the path formed by CUSTOMER and SALES are maintained in sorted order
according to the value of PURCH-DATE. The primary path for INVENTORY is the one
defined by SUP-MASTER and the primary path for SALES is the one defined by
PRODUCT.
Figure 2-5. ORDERS Data Sets and Paths