Skip to content

This project aims to build a railway reservation system which is a software application that handles the entire booking data of the railway. This software can also be used by different railway companies to carry out operations in a smooth, effective, and automated manner.

License

Notifications You must be signed in to change notification settings

Smile040501/RailwayReservationSystem

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

37 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Railway Reservation System

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.

Technologies Used

  • PostgreSQL
  • PLpgSQL

Installation

  • 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
    

ER Diagram

ER Diagram

Structure, Integrity and General Constraints of the Database

Users (Customers with an account and the authority to book tickets)

Passengers (Miscellaneous customers)

Railway Stations

Trains

Schedule

Ticket

Functionalities of the Project

See FUNCTIONALITIES.md for detailed usage.

  • Services for the station_master Role
    • Add a New Railway Station
    • Add a New Train and its Schedule
    • Update the Delay Time of a Train
  • Services for the users Role (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

Design

See DESIGN.md

Contributors

Mayank Singla
Mayank Singla
Satyam Mishra
Satyam Mishra
Aditya Agarwal
Aditya Agarwal

License

MIT

About

This project aims to build a railway reservation system which is a software application that handles the entire booking data of the railway. This software can also be used by different railway companies to carry out operations in a smooth, effective, and automated manner.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published