ISOL 536 Fairleigh Dickinson University Railroad Reservation Case Essay

Aim: The railway reservation system facilitates the passengers to enquire about the trains available based on source and destination, booking and cancellation of tickets, enquire about the status of the booked ticket, etc.

The case study aims to design and develop a database maintaining different trains, train status, and passengers.

PLEASE NOTE THAT YOU ARE NOT DESIGNING A DATABASE. YOU WILL BE WRITING ABOUT SECURITY CONCERNS ABOUT THE DATABASE.

The record of train includes its number, name, source, destination, and days on which it is available, whereas record of train status includes dates for which tickets can be booked, the total number of seats available, and the number of seats already reserved. The database has been developed and tested on Oracle.

Description: Passengers can book their tickets for the train in which seats are available. The passenger has to provide the desired train number and the date for which the ticket is to be booked. Before booking a ticket for a passenger, the validity of the train number and booking date is checked. Once the train number and booking date are validated, it is checked whether the seat is available. If yes, the ticket is booked with confirmed status, and corresponding ticket I.D. is generated, which is stored along with other details of the passenger. After all the available tickets are booked, certain numbers of tickets are booked with waiting status. If the waiting lot is also finished, then tickets are not booked, and a message of non‐availability of seats is displayed.

The ticket once booked can be cancelled at any time. For this, the passenger must provide the ticket I.D. (the unique key). The ticket I.D. is searched, and the corresponding