1 of 25

Railway Booking

System

A Mysql Project

Submitted By:

Raj Kansal - 502304205

Jasmon Kaur - 502304199

Danish Madaan - 502304224

2 of 25

Railway Booking System

The DB Management System that we’ll be designing is Railway Booking System

What is this system all about?

The Railway Booking System is a sophisticated computerized platform mostly used by railway companies to facilitate the booking, reservation, and management of train tickets for passengers.

It comprises of various functionalities such as ticket booking, seat/berth reservation, fare calculation, payment processing, and passenger information management.

3 of 25

Why do we need this system?

We need this system because:

Increases Efficiency: The system streamlines train ticket booking and reservation processes, reducing manual efforts and errors.

Offers Convenience: It offers passengers the ease of booking tickets online, checking seat availability, and planning their journeys ahead of time.

Revenue Management: This system is helpful for Railway companies as they can optimize seat utilization, pricing, and revenue collection through this system.

Provides Insights to the Data: The system collects valuable data for analysis, enabling better decision-making regarding scheduling, route planning, and resource allocation.

4 of 25

WhAT is the scope of this system?

The scope of this system comprises various components of the reservation and booking of tickets - including

online and offline methods
different classes of travel
payment methods, delivery of tickets
seat assignment
and maintenance of passenger data.

It encompasses functions including refunds, cancellations, and integration with other services.

Railway Booking system scope can be scaled further to services like package delivery, travel insurance, and tourism-related bookings, depending on the goals of the railway company and the capabilities of the system.

5 of 25

How does this system work?

Railway booking system involves various steps, wherein a passenger can book tickets, reserve seats,make payments and generate his own ticket. Along with which he can chose to cancel his ticket if he desires to.

Booking: Passengers can access the system through a website or mobile app, select the desired train, date, class, and destination, and make a booking request.

Seat Reservation: Passengers can reserve specific seats or berths based on availability.

Payment: Payment is processed securely using various payment methods.

Ticket Generation: Tickets are generated electronically (e-tickets) or physically and sent to the passenger.

Passenger Information: Passenger data is collected, including identification details, to ensure ticket accuracy.

Cancellations and Refunds: Passengers can cancel tickets, and refunds are processed as per the railway's policy.

6 of 25

How will this system help the organization?

The Railway Booking System offers numerous advantages to the organization:

Increased Revenue: Railway booking system helps in generating revenue by letting the organisation know the number of tickets bought and passengers commuted from one place to another.

Operational Efficiency: Streamlining processes reduces operational costs, minimizes errors, and enhances resource utilization.

Data-Driven Decisions: Access to comprehensive data enables informed decisions regarding scheduling, resource allocation, and service enhancements.

7 of 25

Who are the key stakeholders in this system?

The Railway Booking System involves various stakeholders, including:

Passengers: They are the primary users, booking and traveling on trains.

Railway Authorities: Responsible for managing and operating the railway network, collecting revenue, and leveraging data for operational improvements.

Government Regulators: Govt. regulatory authorities ensure compliance with transportation laws and regulations.

Payment Processors: Entities handling financial transactions between passengers and the railway company.

Ticketing Agents: Travel agencies or vendors that facilitate ticket booking on behalf of passengers.

System Developers and Providers: Companies or organizations responsible for developing, maintaining, and updating the booking system.

Service Providers: Businesses offering additional services integrated into the booking system, such as food vendors, luggage services, and travel insurance providers.

8 of 25

Entities and Attributes

In our project we’ll be working with railway data focused on where a user can provide his details and book a ticket and make payment for the train journey he wishes to travel for. In this we’ll be also mentioning the basic details of a train like route and its class.

The Entities, Attributes(Composite, Multivalued, Derived), Relation and Keys can be seen in the diagram given below, it also contains a legend which helps in understanding the diagram more clearly.

9 of 25

What went well and What didn’t

What went well?

While creating the database the most challenging part for us was to gather data, that can be used within our project. For that we visited various websites containing sample railway data and took insights from it as to how our data should look like, which eventually helped us in shaping our next thing that is ER Diagram and Relational Schema.

What didn’t go well?

While we were preparing our data, we realized that our data(i.e PNR_No column) didn’t supported the values within int data type and contained values which were beyond the limits of int datatype, after getting lot of errors, we realized we have to use another data type that is bigint that can store more bytes of data than an int does.