[an error occurred while processing this directive]

Figure 1: Sample Schema

---

The following is a schema for an IMAGE/SQL database called "ORDERS." All the examples in the text are taken from this sample schema.

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   	>>

CREDIT,         	J2   (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.

The read/write lists associated with each item determine the kind of access users can have. For example, the read/write list associated with the data item CREDIT is

           (8,15/8,15);

This means that people who sign on with a password of SUPER or DO-ALL will have read and write access to this item. But people who sign on as CLERK will not be able to access it.