Online Railway Reservation System

Railway reservation system

1. Online Railway Reservation System SANJAY KUMAR CSE/11/176D

2. Problem statement Information about the route, cancellation of tickets, departure time, arrival time, number of trains available and other such information. Store and retrieve information about the various transactions related to Rail travel. Keep track of all its passengers and thus schedule their journey accordingly. Maintains records of passengers travelling in the different trains on different dates reaching different destinations in the system. User friendly interface to administrator and customer

3. FUNCtions OF USER Train Enquiry Book Ticket Payment Check PNR Status Cancel Ticket Login and Logout

4. Functions of admin Add /Remove Trains Add/Remove User Book Ticket Cancel Ticket Get Passenger List Login and Logout

5. Tables and Normalization

6. username password first_name last_name age email Registration-date username password first_name last_name age email Registration-date Admin table The above table consists of username as a primary key which determines all other attributes of it. There is no partial and transitive dependency so it is in 3NF. The above table consists of username as a primary key which determines all other attributes of it. There is no partial and transitive dependency so it is in 3NF. User table

7. train_no train_name source destination distance arrival_time dep_time Train table Train number is the primary key of train table . It consists of atomic values of attributes and there is no partial and transitive dependency so it is in 3NF . PNR train_no train_name source destination distance class fare arrival_time departure_time Name date seat_no Ticket table

8. train_no train_name source destination distance arrival_time dep_time Train_details train_no class fare Fare table 1 NF – 3 NF conversion of Train table

9. PNR train_no name date seat_no class fare Ticket _details PNR train_no name date seat_no class Ticket1 table PNR fare Ticket2 table

10. train_no General Sleeper Ac I Ac II Ac III Class_details receipt _no username card_no pin_no bank type Payement table

11. triggers If user has entered data in payment, send a trigger to change the value of paid field in ticket (initially set at zero). Confirmation mail to be sent to the user on his email if he has cancelled the ticket or created an account. When a new train is added to the train table the fare table should also be updated.

12. Snapshots

13. THANK YOU