ABSTRACT

 In the age of today, organizations face tremendous challenge in monitoring efficiently the whereabouts, quantity, working condition, depreciation and maintenance status of things of value in their organization. This problem is faced not only by large organizations but also the medium and some smaller organizations. Those things of value known as assets are kept in records by means of inventory. The need to monitor constantly these records of assets cannot be over emphasized as efficient management of the assets inventory of any organization helps maximize the organization's value by making fixed and intangible assets to be easier to locate, more reliable and efficient. This employs tracking the whereabouts, quantity, working condition, depreciation and maintenance status of assets. This is to have at all times, a detailed list of all assets in the organization displaying their description, serial number, acquisition cost, inventory number, respective location, working condition (status) amongst others. This overcomes the manual-based spreadsheet system, which is characterized by error(s), loss of data, varying reports or results at stages involved in the manual-based spreadsheet system. In this paper, waterfall design methodology was used to proffer solution to the problem while the new system will be implemented using JAVA Programming Language (JDK version 1.8) and SQLITE Database Management System and some Application Programming Interface (API) files such as Jcalendar.jar, SQLite.j ar, jtable.j ar. The application was tested over and over again for better evaluation for usability, durability and functionality using various data and with all the interfaces designed.