Skip to content

SQL based data integration project involving various entities of a railways operations management. Used stored procedures, database triggers, temporary views and log tables to track the ticket booking, cancellation and railway employees management modules.

Notifications You must be signed in to change notification settings

ROHANNAIK/Database-Management-Systems-and-Database-Design

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Online Railway Management System

Overview:

The online railway management system is basically a holistic system to track the trains that ply on the routes and also to maintain a repository of the ticket bookings that are made for each trains on each route. India has a vast network of railways and there is a need of a system that can track both the reservations and train services. Taking into consideration the large amount of train services and passenger data it is imperative to consolidate and store the data in a database.

Scope:

Railway operations management system is broadly classified into railway enquiry system, tickets reservation system, repairs and maintenance system. The system provides a functionality to passengers to add themselves to the view the train listings. The user can also update their personal details in the system. The system performs functions like providing the best options of the available trains from a specified source and the destination to the passengers. The train details has comprehensive information like train number, train name, train type, available class types along with respective fares, the frequency of the train during the week, seat availability, route and stoppage details and total distance and total time taken for the journey. Passengers can book their tickets based on their preference and availability. The system also provides a functionality to the passenger to cancel their tickets. At the end of both the transactions the state of the database is restored to its original state. The super admin of the user can add, update and delete new trains from the system, manage stations and route details and also manage passengers.

About

SQL based data integration project involving various entities of a railways operations management. Used stored procedures, database triggers, temporary views and log tables to track the ticket booking, cancellation and railway employees management modules.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published