DEVELOP THE WEB APPLICATION FOR PUSHING THE NOTIFICATION TO INTIMATE THE CURRENT TRAIN TICKET BOOKING

Passengers can quickly check the status of booked tickets, book and cancel tickets, and check the availability of trains depending on origin and destination using the railway reservation system. The case study’s objective is to plan and create a database. Maintain track of the various trains, their state, and their passengers. An introduction to a rail reservation system is part of this project. There is a computerized system for pre-reserving train seats and sending notifications of canceled tickets to those who did not make a reservation. The procedure of making a seat reservation is now more convenient than before. Four hours before departure from the station, activate ticket reservations for current ticket bookings in an existing train reservation system. Passengers are unable to see available seats as a result. So, we had the idea to create a ticket purchasing app that would allow registered passengers’ email addresses to receive push notifications. Those who are waiting for recent reservations will benefit from this. This project also involves designing the relational database for the railway reservation system. Below are a few examples of SQL queries that retrieve information from the train management database