Pseudo-RCTC

Introduction

The Indian Railways (IR) carries about 5.5 lakhs passengers in reserved accommodation every day. The Computerised Passenger Reservation System (PRS) facilitates the booking and cancellation of tickets from any of the 4000 terminals (i.e. PRS booking window all over the countries). These tickets can be booked or cancelled for journeys commencing in any part of India and ending in any other part, with travel time as long as 72 hours and distance up to several thousand kilometres.

In the given project we will be developing a SQL Database which will help users to find train details, enquire about trains running between given two stations, book tickets and know the exact rates of their tickets to the desired destination.

Implementation Details

Users have a unique serial number (SN) used as primary key, name, email, phone, and adminship(decides if the user is an admin or not).
Each station has a unique serial number(PK) and station name.
All routes across the country are present here, each is identified by a serial number and the station which it passes through. One route contains more than one station.
Train entries have a unique train number(PK), name, source, destination, route, number of seats available, start time and end time. One train runs only on one route and has a single sou+rce and destination stations.
Booking details of each ticket contain a unique serial number, user who booked the ticket, train for which the ticket is booked, user’s departure and arrival station. One user may have more than one tickets also many tickets can be booked for the same train. Each ticket can have only one departure and one arrival stations.
Each region has a unique serial number(PK), name and the stations which fall under that region. One region may have more than one station.