The main objective of the Railway Route Optimization project is to help the passengers to know the shortest path to reach the destination as early as possible and within less time and with minimum cost when more than one Railway route is there to reach the destination. This system is very helpful for the tourists and daily passengers. By using this system, the user can know the train details like train starting point and ending point, starting time and arrival time, charge for a starting point to ending point. Also he can view the graphical representation of the train route from starting point to the ending point. This system is very user-friendly and works efficiently.

Description

• Trains

• Route

• Stations

• Search

–          are the four main modules of the Railway Route Optimization System.

Trains module

The train module manages trains table and Train id, train name, starting station, ending station, starting time, ending time and train type are the fields of this table. This module allows operations like additions, modification & deletion and it maintains the information about all trains.

In this module, train id is unique and this attribute does not allow any duplicate values.

Route Module

This module manages the routes table and route-id, starting-station, destination, timetakenforordinary and timetakenforexpress are the fields of routes table. The module maintains the data about routes between railway stations and it shows the graphical representation of a route between starting-station and destination station.

By using this module, the user can know the routes between any two stations and also he can know the shortest path among the routes.

Stations module

This module maintains the stations tables and station-id, station-name, and district, state are the fields of stations table. In this table, Station-id & station-name are unique and they do not allow any unique values. This module manages the information about railway station. The starting station, ending station, via stations must be registered in stations module to arrange a railway route.

Only administrator is allowed to maintain the stations module. After registration of the railway stations, he can arrange the path among those stations.

Search Module

This module provides the reports on trains and routes. It handles the data about trains and routes tables.

1. Administrator

2. Traveler

– are the two main users of this project.

Administrator

The administrator has privileges on Stations, Trains, and Routes tables. He can insert data into these tables and can do the operations like additions, modification & deletion on these tables. After storing the data into these tables, the traveler can send a query on this data for generating the reports. Also, he can easily know the shortest path between two railway stations.

Traveler

The traveler is allowed to search for a train and a route. He can send the queries to server and will get the reports on the requested data. Later, he will get the graphical representation of path between any two railway stations.