Database and Expert Systems Integration - Information Systems Reengineering, Integration and Normalization - page 323

Table 8.3 The result of the knowledge acquisition for the HRM ES
Name Style Type Memo

Find-Employee Rule Boolean “yes”or “no” “high,”

“middle,” or “low”

First-Priority-Group Rule Boolean

Skill-Sufficient Rule Boolean

Display Rule Boolean

Person-id Variable Character

Name Variable Character

Location Variable Character

Preferred-Working-Area Variable Character

Project-Directorate Variable Character

Person-Directorate Variable Character

Staff-Type Variable Character

Age Variable Number

Job-Required-Age Variable Number

Availability Variable Character

Average-Grade Variable Character

Job-Required-Skill-1 Variable Character

Person-Skill-1 Variable Character

Job-Required-Skill-2 Variable Character

Person-Skill-2 Variable Character

”Internal” Atom Character

“High” Atom Character

“Yes” Atom Character

True Atom Boolean

table structure used to represent the result of the knowledge acquisition from an ES.
The schema of the table includes four attributes: name, style, type, and memo. The
name attribute represents the object name in the existing system. The object will
exist in three different kinds of styles, i.e., atom, rule, and variable, in an ES. Atom
means that the object is a fact. Rule means that the object is an inference rule. Vari-
able means that the object value will be generated or supported by another event.
The type attribute represents the content type of the object. Memo is to enable the
developer to write down comments for the object. This will assist the developer
to understand the meaning of the object during the development cycle. Table 8.3
shows the result of the knowledge acquisition for the HRM ES.
The EDS developer needs to know which existing databases will relate to the
new system. The developer also must understand the existing database schema.
There are three ways which the developer can discover the existing database sche-
ma. One way is to go through the database documents to find out its schema. The
second method is to retrieve the database schema from the data dictionary system
of the existing database system. The final method is to use the database conversion