Database design for failure modes and effects analysis

A design for a database system for storing failure modes and effects analysis data has been developed using the E-R (entity-relationship) model to describe the entity sets, relationships, and attributes to a FMEA database. The relational data model can be implemented using any commercially available DBMS (database management system). A detailed discussion of the many advantages of using such a database shows that it is a sound basis for automating the FMEA process. Its usefulness in developing an automated FMEA tool for use in a multiuser environment is also discussed. The database system can also serve as a foundation for developing the analysis component needed for a true FMEA expert system. Using a database for FMEA will also improve the quality of the analysis, and make it more meaningful and visible.<<ETX>>