Business Rules: Capturing the Most Elusive Information Asset - High-Performance Web Databases: Design, Development, and Deployment - page 121

Exhibit 8-3. Data definition language for a business rule database. ( continued )

BUSINESS GUARDIAN

CREATE TABLE BUS_GUARDIAN
(PERSON_ID INTEGER NOT NULL,

GUARDIAN_TYP_CD SMALLINT NOT NULL,

PRIMARY KEY(PERSON_ID),
FOREIGN KEY R/24(PERSON_ID)
REFERENCES PERSON
ON DELETE RESTRICT,
FOREIGN KEY R/B(GUARDIAN_TYP_CD)
REFERENCES GUARDIAN_TYP
ON DELETE SET RESTRICT);
CREATE UNIQUE INDEX XPKBUS_GUARDIAN
ON BUS_GUARDIAN
(PERSON_ID ASC);

BUSINESS RULE

CREATE TABLE BUS_RL
(BUS_RL_ID INTEGER NOT NULL,

BUS_RL_TYP_CD SMALLINT NOT NULL,

BUS_RL_STATUS_CD SMALLINT NOT NULL,

PERSON_ID INTEGER,

DOC_ID INTEGER,

FIRST_PREDICATE_T VARCHAR(50) NOT NULL,

SECOND_PREDICATE_T VARCHAR(50) NOT NULL,

ACTION_TX CHAR(250) NOT NULL,

PRIMARY KEY(BUS_RL_ID),
FOREIGN KEY R/4(BUS_RL_TYP_CD)
REFERENCES BUS_RL_TYP
ON DELETE RESTRICT,
FOREIGN KEY R/6(BUS_RL_STATUS_CD)
REFERENCES BUS_RL_STATUS
ON DELETE RESTRICT,
FOREIGN KEY R/7(PERSON_ID)
REFERENCES BUS_GUARDIAN
ON DELETE RESTRICT,
FOREIGN KEY R/12(DOC_ID)
REFERENCES BUS_DOC
ON DELETE RESTRICT);
CREATE UNIQUE INDEX XPKBUS_RL
ON BUS_RL
(BUS_RL_ID);

GLOSSARY

CREATE TABLE GLOSSARY
(BUS_TERM_ID

CHAR(18) NOT NULL,

PERSON_ID INTEGER NOT NULL,