PHYSICAL DATA MODEL OF CAPE-SAFE

In this section the proposed physical data model of CAPE-SAFE will be highlighted as extracted from the database created in SQL Server. In this experiment, MS-Access has been used as a front-end user interface to display and manipulate the data structure created within SQL Server. 

Accident Table (Plant ID, Plant Location, Accident ID, Accident Description, AccidentCauses, 

Failure Code Table (Failure Code, Description) 

Failure Hierarchy Table (Failure List, Failure Code, Parent) 

Failure Remarks In Work Order Table (WO NO, Description, Entry Date) 

---