This paper presents an approach of using an active database to store asset data. The asset here is referring to motors that are being used for the operation of oil and gas electrical equipments. An Electrical Engineering Department of an Oil and Gas company is now working on a move to restore work process improvement in order to resolve the current problem faced, which is the scattered asset database. With such problem in place, it is important to have an integrated database which allows them to track and record numerous motor histories as well as able to produce constructive information with regards to the overhauling of motors. This project aims to develop an active database whereby it can act as a tool to indicate the progress of work (motor overhaul) by using a traffic light system; e.g. green, yellow and red color-coding based on pre-specified criteria. © 2012 Springer-Verlag GmbH.