Volume 18, No. 6, 2021

The Role Of Relational Database Management System (RDBMS) Strategies In Vehicle Management Of WASA-FDA


Sajjad Hussain Qureshi , Muhammad Danial Jan , Muhammad Sohaib Akram

Abstract

Transport cell of WASA (water and sanitation agency) Faisalabad is facing problems in manual maintaining of vehicles in the organization. The cell records transactions manually on registers having many shortfalls. It is more time consuming, lack of accuracy, possibility to lose record and control. There is a need of computer based system having strong database model. The proposed system was user friendly, graphical user interphase and based on relational database management system. The entity-relationship (E-R) model, was utilized to create a conceptual database architecture for an information system that was implemented using a relational database management system. Database designers created natural third forms of associated databases for the efficient operation of an information system by using the entity-relationship data modelling technique. An interactive, efficient, user friendly, client server based system was developed by using Oracle (database) as backend and developer as front end. The proposed system was capable of generating different reports. It included all the procedures for transport facility, maintenance of vehicles and transport records. Finally, proposed system helps transport incharge to take better control over the transactions that take place between user and transport cell. This proposed system would help the staff in assembling the information in useful shape. It assists top management in interpreting the new transportation requirements, its maintenance and disposal of vehicles of WASA.


Pages: 9916-9930

Keywords: RDBMS, transport, Oracle, Developer.

Full Text