Research Area:
Software Engineering
KeyWord:
data, database, diagnosis, management, organization, test, query
Abstract:
The business performance in many organizations is enhanced through the effectiveness and efficiency of their database management system. Management decision making is best achieved when the available data is at the right hand of decision makers to analyze a given scenario. Customer best service is rendered when data redundancy is eliminated. The entity overall bottom-line profit result is yielded when all the easily accessible data mixed together gives higher net profit above the total operational cost. However, the traditional way of managing data establish a major problem that affects their daily business operation. The technological advancement in every sector is driving change to all organizations; as there is need for them to catch up with the need of the moment by creating a DBMS that will help their day-to-day operations. The challenges of accurately recording data, storing, updating and tracking are the major problems faced by Uniongate Diagnostic Center because of the manual means of operations. They can overcome the problems of working manually with data by perusing the benefits of database management systems. The use of database will increase the efficiency of business operations and reduce overall costs. Database management system is used to stores, organizes and manages a large amount of information within a single software application. The data is entered into the system and it is accessed on a routine basis by assigned users. The users has an assigned password to gain access to the system. The project is developed for Uniongate Diagnostic center Akure Ondo State, Nigeria. The development of a relational database for the diagnostic center was implemented successfully using the Apache Server with MySQL running as the back end and PHP used as the server-side language. The results obtained show that the use of relational databases has reduced data storage costs, eliminate data redundancy, remove data inconsistencies and avoid duplicate processing. The overall business efficiency has improved significantly and work processes simplified with least time of data query.