Answer to Question #255981 in Databases | SQL | Oracle | MS Access for Rasel Sheikh

Question

Railway Management System

The Main aim of the Railway

Management Mini DBMS project is

to ease the process of railway

reservation. We aim to

demonstrate the use of create,

read, update and delete MySQL

operations through this project. In

this project, we first add the details

of trains and their halting stations.

Then passengers can book a ticket

by adding their details, source and

Destination. Passenger module

shows the number of passengers

boarding to the station. Trains and

Stations can be added or deleted

and the train details can be

updated for changing the timing on

arrival and departure or just

increasing or decreasing the

amount for tickets based on

classes such as 2A,3B,etc.

Answer 1

The system requires tables like passengers, trains, stations, and transactions. The table passengers will contain the details of passengers like their names source, station, and destination station. The table trains will carry the details of the train like the capacity and names of the trains. A station table will have details such as the arrival and departure times of trains. The table transaction will link the passengers, station, and trains tables.