DEVELOPMENT OF AN INFORMATION SYSTEM TO MANAGE VEHICLE REPAIR AND MAINTENANCE D E TA ILS O F SRI LANKA T E LE C O M l

Abstract

The transport section of Sri Lanka Telecom (SLT), repair and maintain the entire vehicles belongs to SLT. The information related to vehicle repairs was handled by transport section using a computer base system. But part of the information related to vehicle repairs was handled manually because the existing system contained limited number of operations. Further the existing system did not meet all the user requirements. The aim of this project was to develop user-friendly software system to handle all the information related for vehicle repairs and maintenance.After analyzing the project the linear sequential method was used. First the functional requirements were analyzed by interviewing the top-level management and some potential users of the system of the transport section. Then a database was developed using Microsoft Access to meet the functional requirements. Next the interfaces and reports were developed using Visual Basic (VB). The interface and reports were connected to the database using Structured Quarry Language (SQL). Then all interfaces and tables were subjected to both unit testing and system testing. Finally the management of the transport section of the SLT accepted the system. The outcome of this project was a more user friendly and more efficient software system to handle all the information related for vehicle repairs and maintenance.The system contained 10 forms, 03 reports and 01 database with 10 tables.Results of testing, verification and validation procedures revealed that it matches with the original user requirements. The robustness of the system adds a strong point to its acceptability thus ensuring that it is less likely to collapse.Allowing the online access for the users and providing report-generating tool such as Seagate Crystal Reports could further develop the system.