This project aims to build a railway reservation system which is a software application that handles the entire booking data of the railway. It has been developed to override the problems prevailing in the practical manual system. It is fully based on the concept of reserving train tickets for various destinations reliably and consistently. It reduces the stress and workload of the employee who books the ticket. It also lets the travelers book and finds schedules for the trains with ease. This software can also be used by different railway companies to carry out operations in a smooth, effective, and automated manner.
- PostgreSQL
- PLpgSQL
- Install postgres
- Clone this repository
$ git clone [email protected]:Smile040501/RailwayReservationSystem.git
- Change the directory to the source code directory
$ cd RailwayReservationSystem/src - Start psql and execute the makefile.sql.
The passwords for the testing users are their names itself which needs to be entered for every execution of the makefile.$ psql -U postgres
postgres=# \i makefile.sql
Users (Customers with an account and the authority to book tickets)
Passengers (Miscellaneous customers)
Railway Stations
Trains
Schedule
Ticket
See FUNCTIONALITIES.md for detailed usage.
- Services for the
station_masterRole- Add a New Railway Station
- Add a New Train and its Schedule
- Update the Delay Time of a Train
- Services for the
usersRole (Customers with an account)- Book Tickets
- Cancel Booking
- Services for everyone
- Create a New Account and Register as a Customer
- Available Trains Between Two Given Stations On a Given Date
- Full Schedule of a Given Train
- Schedule of Different Trains at a Given Station
- Fare of a Given Train Between Two Given Stations
- Get Details of a Passenger Given PNR
- Number of Seats Available in a Given Train Between Two Given Stations on a Given Date
- Check Ticket Status
- Check Delay Time of a Train
See DESIGN.md
Mayank Singla |
Satyam Mishra |
Aditya Agarwal |