:RUN DBSCHEMA.PUB.SYS;STDIN=SCHEMA


PAGE 1      HEWLETT-PACKARD 30391C.07.04  TurboIMAGE/3000: DBSCHEMA

BEGIN DATA BASE ORDERS;  << CUSTOMER ORDERS >> 


PASSWORDS: 

4 CLERK;        << SALES CLERK >> 
8 SUPER;        << SUPERVISOR OF CUSTOMER ORDERS DEPARTMENT >> 
15 DO-ALL;      << PROGRAMMER/ANALYST - CREATOR OF DATA BASE>> 


ITEMS:               << (READ / WRITE) >> 

ACCOUNT,        X6   (4,8,15/8,15);    << CUSTOMER ACCT=AA-NNN  >> 
CITY,           X14  (4,8,15/8,15);    << CUSTOMER CITY         >> 
DATE,           X6   (4,8,15/8,15);    << DATE = DDMMYY         >> 
DELIV-DATE,     X6   (4,8,15/8,15);    << DEL. DATE = DDMMYY    >> 
FIRSTNAME,      X10  (4,8,15/8,15);    << CUSTOMER NAME         >> 
LASTNAME,       X16  (4,8,15/8,15);    << CUSTOMER NAME         >> 
PRICE,          J2   (4,8,15/8,15);    << PRODUCT UNIT PRICE    >> 
QTY,            J2   (4,8,15/8,15);    << QUANTITY OF ITEMS     >> 
PART-NO,        X8   (4,8,15/8,15);    << PRODUCT PART NUMBER   >> 
PART-NAME,      X14  (4,8,15/8,15);    << PRODUCT DESCRIPTION   >> 
STREET,         X26  (4,8,15/8,15);    << CUSTOMER STREET ADDR  >> 
TOTAL,          J2   (4,8,15/8,15);    << TOTAL OF PURCHASES    >> 
ZIPCODE,        X6   (4,8,15/8,15);    << CUSTOMER ZIPCODE      >> 

SETS: 

NAME:             CUSTOMER,MANUAL(4,8,15/8,15); 

ENTRY:            ACCOUNT(1), 
                  LASTNAME, 
                  FIRSTNAME, 
                  STREET, 
                  CITY, 
                  ZIPCODE; 

CAPACITY:         201; 

NAME:             DATE-MASTER,AUTOMATIC; 

ENTRY:            DATE(1); 

CAPACITY:         211; 

NAME:             SALES,DETAIL(4,8,15/8,15); 

ENTRY:            ACCOUNT(CUSTOMER), 
                  DATE(DATE-MASTER), 
                  PART-NO, 
                  PART-NAME, 
                  QTY, 
                  PRICE, 
                  TOTAL, 
                  DELIV-DATE; 

CAPACITY:         1231; 

END. 

 DATA SET    TYPE  FLD  PT  ENTR  MED  MAXIMUM    BLK  BLK  DISC  
   NAME           CNT  CT  LGTH  REC  CAPACITY   FAC  LGTH SPACE  

CUSTOMER        M  6    1  39    50   201        10   501  96       
DATE-MASTER     A  1    1  3     14   211        36   507  32       
SALES           D  8    2  26    34   1245       15   511  336      

                        TOTAL DISC SECTORS INCLUDING ROOT: 480      

NUMBER OF ERROR MESSAGES: 0     

ITEM NAME COUNT: 13      DATA SET COUNT: 3     

ROOT LENGTH: 908         BUFFER LENGTH: 511     TRAILER LENGTH: 256    

ROOT FILE ORDERS CREATED.

END OF PROGRAM
: