ENFORM User's Guide

Appendix C Sample Data Base
058058 Tandem Computers Incorporated C–1
All of the examples in this guide, use the sample relational data base in this appendix.
Refer to the Data Definition Language (DDL) Programming Manual for a more complete
description of the structure of a data base. This sample data base has two subsections:
order entry records and employee records. The order entry records contain
information on the parts in stock and orders for parts. The employee records contain
information on the personnel and the organization of the company.
The names of the sample data base records and their contents are as follows:
Order entry records
order invoice for parts
customer customer information
fromsup purchase orders for parts from supplier
odetail detailed invoice for parts
parts inventory of parts in stock
supplier supplier information
Employee records
region regional information
branch branch information
employee employee information
Each file has designated key fields on which different files may be linked. Figure C-1
indicates the relationships between the files by arrows.