HP 3000 Manuals HP 3000 Manuals
Appendix A Schema for SAMPL1 Database
$TITLE "INFORMATION ACCESS SAMPLE DATABASE 1: ORDER MANAGEMENT (SAMPL1)"
BEGIN DATA BASE SAMPL1; << This is one of two sample databases >>
<< included with the Information Access >>
<< product. Along with SAMPL2 it will be>>
<< used in the tutorial for the DBAs. >>
<< Both are required if the tutorial is >>
<< used. This database is for use by >>
<< an office supply company. >>
PASSWORDS:
10 CLERK; << SALES CLERK >>
20 BUYER; << PURCHASING AGENT >>
30 SALES; << SALES REPRESENTATIVE >>
40 SHIP; << SHIPPING CLERK >>
50 MGR; << OPERATIONS MANAGER >>
<< DATA ITEMS in ALPHABETICAL ORDER >>
ITEMS:
ACCOUNT, X6; << ACCOUNT NUMBER, ALPHANUMERIC, 6 CHAR >>
ADDRESS, X30; << CUSTOMER STREET,ALPHANUMERIC, 30 CHAR >>
CITY, X10; << CITY, ALPHA, 10 CHAR >>
CUSTOMER, X24; << CUSTOMER NAME, ALPHANUMERIC, 24 CHAR >>
EMP-NBR, X6(30,50/50);<< SALES REP EMPLOYEE NUMBER, 6 CHAR >>
OFFICE, X10; << OFFICE OF SALES REP, ALPHA, 10 CHAR >>
ORDER-DATE, X6; << DATE, YYMMDD, 6 CHAR >>
ORDER-DEPOSIT, P8; << $ DEPOSIT ON ACCOUNT, 5 DIGITS W/SIGN >>
ORDER-NOTES, X20; << NOTES RE ORDER, ALPHANUMERIC, 20 CHAR >>
ORDER-QTY, P8; << QUANTITY ORDERED, 7 DIGITS W/SIGN >>
PHONE, X14; << SALES REP PHONE,(999) 999-9999,14 CHAR>>
PRODUCT-NBR, X6; << PRODUCT NUMBER, ALPHANUMERIC, 6 CHAR >>
SALES, 12P8; << MONTHLY SALES TOTALS PER SALES REP >>
SALES-REP, X24; << LASTNAME,FIRST, ALPHA, 24 CHAR >>
SHIP-DATE, X6; << SHIPPING DATE, YYMMDD, 6 CHAR >>
STATE, X2; << STATE, ALPHA, 2 CHAR >>
SETS:
<< 1 >> NAME: CUSTOMER-MASTER, MANUAL (10,20,30,40,50/10,30,50);
ENTRY: ACCOUNT(1), << ONE PATH TO ORDER-DETAIL >>
CUSTOMER,
ADDRESS,
CITY,
STATE;
CAPACITY: 47;
<< 2 >> NAME: SALES-STAFF, MANUAL (10,30,40,50/40,50);
ENTRY: SALES-REP,
EMP-NBR (1), << PATH ORDER-DETAIL >>
OFFICE,
PHONE,
SALES;
CAPACITY: 11;
<< 3 >> NAME: DATE-MASTER, AUTOMATIC; << ORDER DATE INDEX >>
ENTRY: ORDER-DATE(1);
CAPACITY: 101;
<< 4 >> NAME: ORDER-DETAIL, DETAIL (/10,30,50);
ENTRY: ACCOUNT (CUSTOMER-MASTER),
EMP-NBR (SALES-STAFF),
PRODUCT-NBR,
SHIP-DATE,
ORDER-DATE(DATE-MASTER),
ORDER-DEPOSIT,
ORDER-NOTES,
ORDER-QTY;
CAPACITY: 101;
END.