Design of a Database for Bus Fleet Management

Shubham V. Patil; Swapnali S. Koli; Saurabh S. Lahamate; Chow Anu Chowlu

Abstract

State transport buses are a means of efficient mass transport in a populous country like India. But, the efficiency of this system is threatened by over dependence on file management system. Unexpected and unusual road conditions aggravate this problem. Frequent on-road breakdowns, poor punctuality, and poor bus conditions are reasons enough for travelers to ditch the state transport in favor of private bus operators, thus, no wonder the state transports are currently in huge losses. In this fast paced world, none is willing to lose time waiting for the bus. Using a simple system of RFID, some sensors, and a GSM module coupled with database based on MS Excel, this paper presents a very simple and a cost – effective solution thus, helping to maintain a healthy, punctual bus fleet while also serving as an effective medium for bus health monitoring and tracking by both, the fleet owners as well as the consumers.

Keywords

State transport, MSRTC, Radio Frequency Identification (RFID), Global System for Mobile Communication (GSM), Database Management System (DBMS), Fleet Management

References

[1] Sanjay Kumar Singh, VenkateshAnand, 2004,Comparing efficiency across state transport undertakings: a production frontier approach, Indian Journal of Transport Management, Vol. 27, No. 3, (July 2004) 374-391. DOI=http://dx.doi.org/10.2139/ssrn.572722

[2] https://msrtc.maharashtra.gov.in/index.php/node/index/143

[3] http://www.sakaltimes.com/maharashtra/9-st-buses-breakdown-every-day-23459

[4]https://timesofindia.indiatimes.com/city/pune/shivneribus-knocks-down-three-police-fault-doormechanism/articleshow/62701433.cms

[5] https://punemirror.indiatimes.com/pune/civic/msrtc-busted/articleshow/62715784.cms

[6] S. Saritha, Sai Meenakshi Raja, Noor Mohammed. S, 2017, RFID based bus management system, IJARIIE, Vol-3 Issue-2 2017.

[7] Rahul Bandhan, Saloni Garg, Bipin Kumar Rai, Gaurav Agarwal, 2018, Bus management system, International Journal of Advanced Research in Computer Science, Volume 9, No. 3, May-June 2018, DOI=https://doi.org/10.26483/ijarcs.v9i3.5821

[8] I. Ashour, M. Zorkany, M. Shiple, 2015, Design and implementation of transportation management system, In Proceedings of the International Conference on Vehicle Technology and Intelligent Transport Systems(Lisbon, Portugal, May 20-22, 2015), 11 - 18. DOI=10.5220/0005430200110018

[9] M. Malleswari, M. Koteswara Rao, K. V. Supriya, K. Pavan Krishna, B. Ravi Teja, 2018, RFID based college bus management system, International Research Journal of Engineering and Technology, Volume: 05 Issue: 03, Mar2018, 1666 – 1668.

[10] M. A. Hannan, A. M. Mustapha, A. Hussain, H. Basri, 2012, Intelligent bus monitoring and management system, In Proceedings of the World Congress on Engineering and Computer Science2012 Vol II WCECS 2012(San Francisco, USA, October 24-26, 2012), ISBN: 978-988-19252-4-4ISSN: 2078-0958 (Print); ISSN: 2078-0966 (Online).

[11] https://ianshires.mycouncillor.org.uk/2015/03/06/businformation-the-square-new-invention/

Cites this article as

S. V. P. , S. S. K. , S. S. L. , C. A. C. , "Design of a Database for Bus Fleet Management", International Journal of Innovative Research in Engineering & Management (IJIREM), Vol-5, Issue-6, Page No-196-200, 2018. Available from: