Synopsis: Railways Reservation
Synopsis: Railways Reservation
Synopsis: Railways Reservation
RAILWAYS RESERVATION
OBJECTIVE- Designing a Database that gives us information about railway
reservation of
tickets. This database helps railways to retrieve data as and when required in
future.
INTRODUCTION
Layout of railway reservation form and connection of this form with the
database required to store information.
PASSENGERS DATABASE : database of passengers contains following fields
1. Name
2. Age
3. Gender..
4. Total Number Of Passengers Travelling
Number of Adults..
Number Of children..
Senior Citizen
5. Date Of Travel
6. Class of Travel..
TRAIN DATABASE : database of train contains following fields
1. Train Name.
2. Train Number..
3. RouteFrom..To..
4. Train Time
5. Number of Compartments.
AC First Class
AC 2 Tier
AC 3 Tier
Sleeper..
General.
6. Number of Employees.
INTRODUCTION
HISTORY
A plan for a rail system in India was first put forward in 1832, but no further
steps were taken for
more than a decade. In 1844, the Governor-General of India Lord Hardinge
allowed private
INTRODUCTION TO THE
RESERVATION
SYSTEM
The Indian Railways (IR) carries about 5.5 lakh passengers in reserved
accommodation every
day. The computerised Passenger Reservation System (PRS) facilitates
booking and cancelling
of tickets from any of the 4000 terminals (i.e PRS booking windows) all over
the country. These
tickets can be booked or cancelled for journeys commencing in any part of
India and ending in
any other part, with travel times as long as 72 hours and distances up to
several thousand
kilometers.
The pilot project of PRS was launched on 15 November 1985, over Northern
Railway with the
installation of the Integrated Multiple Train Passenger Reservation System
(IMPRESS), an
online transaction processing system developed by the Indian Railways in
association with
Computer Maintenance Corporation (CMC) Ltd., at New Delhi. The objective
was to provide
ONLINE BOOKING:
This facility is given to general public by railway department. With the help of
this
facility people can book their tickets through internet, sitting in their home
by a single click of
the mouse. Using their credit card people can easily get their tickets done
within minutes. There
are certain charges for online booking as well.
COUNTER BOOKING:
This is oldest method of booking the ticket. The reservation counters are
there at
railway departments from where people can get the tickets to their
respective destinations.
Nowadays there are various ticket counters, apart from railway station
counters where tickets are
available.
there will be
very less rush and shorter queues at the reservation counters or centers.
In the proposed system, we are also making database for all the trains
running across the
country.
As required, we can edit the database of the trains and also add the new
trains which will
be proposed in future budgets
are in waiting list or confirmed need not travel to the ticket counter or call
railway service
system. With the help of an online system they can show the information in a
click.
In case of cancellation, the online system instantly credits the amount from
the
passengers account.
It updates the changes instantly, thus, the user working on the database
will not have to
go to each database and make the changes