Rules

Oracle 7 insert statements generated from the OPM schema shown in section 3 for implementing OPM data rules are contained in file Example_datarules.ORA7:

INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (0, NULL, NULL, 'OBJECTS', 'OBJECTS', 'Object');
INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (2, NULL, NULL, NULL, 'PERSON', 'Object');
INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (3, NULL, NULL, NULL, 'FACULTY', 'Object');
INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (8, NULL, NULL, NULL, 'PROFESSOR', 'Derived Subclass');
INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (4, NULL, NULL, NULL, 'STUDENT', 'Object');
INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (5, NULL, NULL, NULL, 'COURSE', 'Object');
INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (6, NULL, NULL, NULL, 'DEPARTMENT', 'Object');
INSERT INTO CLASSES ("_cid", "_dbid", "_alias", "_classDescr", "_className", "_type")
VALUES (7, 0, 'Publication', 'References in PUBLICATIONS database', 'REFERENCE', 'Foreign');

INSERT INTO DATABASES ("_dbid", "_dbDescr", "_dbName")
VALUES (0, 'database for course references', 'PUBLICATIONS');

INSERT INTO DepartmentNames ("_code", "_defn", "_value")
VALUES (1, NULL, 'Computer Science');
INSERT INTO DepartmentNames ("_code", "_defn", "_value")
VALUES (2, NULL, 'Engineering');

INSERT INTO SCLASSES ("_class", "_subclass")
VALUES (0, 2);
INSERT INTO SCLASSES ("_class", "_subclass")
VALUES (2, 3);
INSERT INTO SCLASSES ("_class", "_subclass")
VALUES (2, 4);
INSERT INTO SCLASSES ("_class", "_subclass")
VALUES (0, 5);
INSERT INTO SCLASSES ("_class", "_subclass")
VALUES (0, 6);
INSERT INTO SCLASSES ("_class", "_subclass")
VALUES (0, 7);