Designing the application and of Railway Reservation System for the purpose of reserving railway tickets and database maintenance about train and passenger details by the railway department only. This database helps railways to retrieve data as and when required in future.
The scope of project included evaluation of the application and was primarily concerned with the transactions related to booking of tickets from the terminals operated by the railway personnel.
Application controls and simulation were used to evaluate data validation and program logic. The selected data, as made available, for substantive checking of the completeness, integrity and consistency of data using computer assisted applications such as VB, MS Access.
The records maintained in the database of the railways reservation centre were also reviewed. Discussions were held with the database users to gain understanding regarding the various functional aspects of the system.
The booking database has passenger’s details like Name, Age, Gender, Total Number of Passengers Traveling, Date of Travel, and Class of Travel.
The train database has train details like Train Name, Train Number, Route, From, To, Train Time, AC First Class, AC 2 Tier, AC 3 Tier, Sleeper, Second Sitting and Quota Management like General, Takkal.
Windows XP Professional.
Visual Basic 6.0.
Pentium IV 3.0GHz Processor
512 MB RAM
80 GB Hard Disk
In our Railway Reservation System, there are four main modules available. They are
1. Train Master
2. Ticket Booking
3. Ticket Canceling
1. Train Master:
The Train Master is Admin side module. The Administrator only can Add, modify and Delete the train Details. The Train Master contains the following details.
a) Train Name
b) Train No
e) Departure Time
f) Arrival Time
g) Total Seats
i) General Seats (1A, 2A, 3A, 2S, SL, CC)
j) Takkal Seats (1A, 2A, 3A, 2S, SL, CC)
k) Routes and Timings
2. Ticket Booking:
The Ticket Booking is user (Employee of Railway Dept.) side module. The user can book the ticket using this module. The user should follow the steps for the ticket booking.
a) First you should select the Source and Destination.
b) Next, you should select the Date. While the date textbox got focus, the calendar will display. By clicking the calendar, the date will be selected. And you can’t select the yesterday and before date.
c) Select the Quota (General or Takkal).
d) Click the Find button to find the trains which are available.
1. If you select the Takkal Quota and the date is day after tomorrow in the sense, you can’t book the ticket for Takkal Quota for that day. The Takkal Quota will enable only today and tomorrow only.
e) After clicking the find button, the available train list will be displayed in the flexgrid.
f) By clicking the train number or train name in the flex grid, the “Route” button enabled. By clicking the route button, the corresponding train route, timings, and kms.
g) By clicking the class column to the corresponding train whichever you want to travel, then “Book” button will enable.
h) Click the “Book” button to enter the Name, Age, Sex and Berth.
i) After Enter the details, Click the Proceed Button.
j) The frame will display the overall details like Source, Destination, Travel Date, Booked Date, Total Members, Quota and Total Fare.
k) Click the “Confirm” Button to confirm the details. Then only the Booking details will be stored and PNR Number will be generated.
3. Ticket Canceling:
The Ticket Canceling is also user (Employee of Railway Dept.) side module. The user can cancel the ticket using this module. The user should follow the steps for the ticket Cancel.
a) Enter the PNR Number in the Textbox and Click Find.
b) It will show the details like Train No., Train Name, Booked Date, Travel Date, Source, Destination, Class, Quota, Total Fare, Kms in the Frame.
c) It also shows the passenger names, Age, Sex, Berth, Class, Fare and status in the flex grid.
d) Click the Name in the flex grid which you want to cancel and where the status is “Booked”.
e) Click the “Cancel” Button to cancel the ticket.
The Report Module is also user (Employee of Railway Dept.) side Module. The user can take two types of reports by giving the PNR Number.
a) Booked Tickets
b) Canceled Tickets