HP 3000 Manuals HP 3000 Manuals
Appendix B Schema for SAMPL2 Database
$TITLE "INFORMATION ACCESS SAMPLE DATABASE 2: INVENTORY CONTROL (SAMPL2)"
BEGIN DATA BASE SAMPL2; << This is one of two sample databases >>
<< included with the Information Access >>
<< product. Along with SAMPL1 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's warehouse. >>
PASSWORDS:
10 CLERK; << SALES CLERK >>
20 BUYER; << PURCHASING AGENT >>
30 AUDITOR; << AUDITOR >>
40 SHIP; << SHIPPING CLERK >>
50 MGR; << WAREHOUSE MANAGER >>
<< DATA ITEMS in ALPHABETICAL ORDER >>
ITEMS:
BACKORDERFLG, X2; << BACKORDER FLAG, ALPHANUMERIC, 2 CHAR >>
ON-HAND-QTY, P8; << ON-HAND QUANTITY, 5 DIGITS W/SIGN >>
PRICE, P8; << SELLING PRICE, 5 DIGITS W/SIGN >>
PROD-DESCRIPT, X30; << FIELD-ENTERED DESCR, ALPHA, 30 CHAR >>
PROD-NOTES, X10; << PRODUCT NOTES, ALPHANUMERIC, 10 CHAR >>
PRODUCT-NBR, X6; << PRODUCT NUMBER, ALPHANUMERIC, 6 CHAR >>
PRODUCT-TYPE, X6; << PAPERS,PENS,ETC., ALPHANUMERIC, 6 CHAR >>
UNIT-COST, P8; << COST PER UNIT, 5 DIGITS W/SIGN >>
VENDOR-NAME, X30; << VENDOR NAME FOR PRODUCT, 30 CHAR >>
WAREHOUSE, X12; << WAREHOUSE NAME, ALPHANUMERIC, 10 CHAR >>
SETS:
<< 1 >> NAME: PRODUCT-MASTER, MANUAL (10,20,30,40,50/20,30,50);
ENTRY: PRODUCT-NBR(1),
PROD-DESCRIPT,
VENDOR-NAME,
PRODUCT-TYPE,
UNIT-COST,
PRICE,
PROD-NOTES;
CAPACITY: 101;
<< 2 >> NAME: WAREHOUSE-MASTER, AUTOMATIC;
ENTRY: WAREHOUSE(1);
CAPACITY: 11;
<< 3 >> NAME: INVENTORY, DETAIL (/20,30,40,50);
ENTRY: PRODUCT-NBR (PRODUCT-MASTER),
WAREHOUSE (WAREHOUSE-MASTER),
BACKORDERFLG,
ON-HAND-QTY;
CAPACITY: 101;
END.