ENFORM User's Guide

Sample Data Base
C–6 058058 Tandem Computers Incorporated
Figure C-3. Listing of Records in Sample Relational Data Base (Page 1 of 5)
ORDER Records:
ORDERNUM OMONTH ODAY OYEAR DMONTH DDAY DYEAR SALESMAN CUSTNUM
-------- ------ ---- ----- ------ ---- ----- -------- -------
21 1 10 78 4 10 78 205 1234
25 1 23 78 6 15 78 212 7777
30 2 6 78 7 1 78 222 926
32 2 17 78 7 20 78 204 21
35 3 17 78 8 10 78 231 543
38 3 19 78 8 20 78 218 123
41 3 27 78 9 1 78 207 7654
45 4 20 78 9 15 78 212 324
48 5 12 78 10 10 78 225 3333
51 6 1 78 10 20 78 210 143
66 7 9 78 11 1 78 205 3210
122 7 21 78 12 15 78 221 5635
CUSTOMER Records:
CUSTNUM CUSTNAME ADDRESS CITY STATE
------- ------------------ ---------------------- -------------- ----------
21 CENTRAL UNIVERSITY UNIVERSITY WAY PHILADELPHIA PENN
123 BROWN MEDICAL CO 100 CALIFORNIA STREET SAN FRANCISCO CALIFORNIA
143 STEVENS SUPPLY 2020 HARRIS STREET DENVER COLORADO
324 PREMIER INSURANCE 3300 WARBASH LUBBOCK TEXAS
543 FRESNO STATE BANK 2300 BROWN BLVD FRESNO CALIFORNIA
926 METTALL-AG. 12 WAGNERRING FRANKFURT GERMANY
1234 DATASPEED 300 SAN GABRIEL WAY NEW YORK NEW YORK
3210 BESTFOODS MARKET 3333 PLELPS STREET LINCOLN NEBRASKA
3333 DEUTSCHE STAHL SIEMENS-STRASSE DUISBERG GERMANY
5635 VEREINIGTE CHEMIE 45 FRANKENSTRASSE MUENCHEN GERMANY
7654 MOTOR DISTRIBUTING 2345 FIRST STREET CHICAGO ILLINOIS
7777 SLEEPWELL HOTELS 9000 PETERS AVENUE DALLAS TEXAS