DESIGN AND IMPLEMENTATION OF A MYSQL BASED DATABASE FOR AN ONLINE FAULT REPORTING SYSTEM

Abstract

In this paper, a Mysql-based database was developed for the implementation of an online fault reporting system for a utility company. The Ikeja zone Power Holding Company of Nigeria, now Ikeja Electric Company was used as the case study utility company. A use case diagram was used to depict major requirements of the system and their roles in the system being created. An activity diagram showed the direction of flow of information in the database while an entity relation diagram depicted the relationship between the key tables that formed the database. The database tables resulted from a progressive normalization of the unnormalized table from first normal form to third normal form tables. The designed database was implemented in Mysql platform. Result of test conducted on the system showed that the developed database is able to accept inputted data, store accepted data in the right tables and allow retrieval of the data with the correct queries. In conclusion, the developed system was found to be functional, effective and with the ability to support a dynamic online fault reporting system. It is recommended that future researchers in this area should consider equipping the database with security features that will guarantee the integrity of the data it is holding