Eloquence Sort Manual

A Schema Listing for the SAD Data Base

         $CONTROL               LIST, TABLE, ROOT
         $TITLE  "Sales Analysis Data Base"

         BEGIN DATA BASE    SAD;  <<CUSTOMER SALES ANALYSIS DATA BASE>>

         PASSWORDS:                 <<Password definition>>
                            10      SALESMAN;
                            15      MANAGER;
                                      3        SECRTARY; <<WILL HAVE READ ACCESS ONLY>>

         ITEMS                      <<Item definition>>

                            ADDRESS,           2 X30; 
                                    <<2 LINES OF ADDRESS ALLOWED>>
                            CITY,                X16;
                            COUNTRY,             X12;
                                    <<PATH FOR ORDER-DATE, SHIP-DATE>>
                            DATE,                I;
                            NAME,                X30;
                            OPTION-DESC,         X10;
                            OPTION-PRICE,        L;
                            OPTION-TYPE,         I;
                            ORDER-DATE,          I;   <<MUST BE YYMM>>
                            ORDER-NO,            X10;
                            PRICE,               L;
                            PRODUCT-NO,          I;
                            PROD-DESC,           X30;
                            REGION,              X6;
                            REGION-DESC,         X30;
                            REGION,TYPE,         I;
                            SALESPERSON,         X4;
                            SHIP-DATE,           I;    <<MUST BE YYMM>>
                            STATE,               X6;
                            ZIP-CODE,            X8

            SETS:                          << Set defintion >>


            NAME:        DATE,  A (3/10,15);
            ENTRY:       DATE (2);
            CAPACITY:    51;

            NAME:        ORDER, A (3/10,15);
            ENTRY:       ORDER-NO (2);
            CAPACITY:    101;

            NAME:        PRODUCT, M (3,10/15);
            ENTRY:       PRODUCT-NO (1)
                         PROD-DESC; (1)
            CAPACITY:    11;

            NAME:        LOCATION, M(3,10/15);
            ENTRY:       REGION (1),
                         REGION-DESC,
                         REGION-TYPE;
            CAPACITY:    17;

            NAME:        OPTION, D (3/10,15);
            ENTRY:       ORDER-NO (ORDER),
                         OPTION-DESC,
                         OPTION-PRICE,
                         OPTION-TYPE;
            CAPACITY:    300;

            NAME:        CUSTOMER, DETAIL (3/10,15);
            ENTRY:       ORDER-NO (ORDER),
                         NAME,
                         ADDRESS,
                         CITY,
                         STATE,
                         COUNTRY,
                         ZIP-CODE,
                         ORDER-DATE (DATE),
                         SHIP-DATE (DATE),
                         REGION (LOCATION),
                         PRODUCT-NO (PRODUCT),
                         PRICE,
                         SALESPERSON;
             CAPACITY:   100;

             END