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

Transportation expert system rule:

Rule Air-transportation

IF Centre-distance > 1500 and Centre-food-type =

perishable

THEN Transportation-type = air

Rule Train-transportation

IF Centre-distance > 1500 and Centre-food-type = bulk

THEN Transportation-type = train

Rule Ship-transportation

IF Centre-distance ≤ 1500

THEN Transportation-type = ship

Show the steps of integrating the above expert system rules and the database table
into an expert database system using a Frame model metadata approach.

Question 8.2
You are to develop an expert database system by integrating the following data-
base and expert rule for a manufacturing inventory system to derive all subparts of
each part.

SUBPART database table:

Field-Name Type Width

SUB-PART Character 10

PART Character 10

Transportation expert system rule:

Rule Subpart

IF a Subpart's Part = another part's subpart

THEN the Subpart = another part's subpart