07-07-2012, 03:29 PM
Online Railway Reservation
Online Railway Reservation.pdf (Size: 963.48 KB / Downloads: 461)
INTRODUCTION
This project aims at development of an Online Railway Reservation Utility which facilitates the Railway customers to manage their reservations online, and the Railway administrators to modify the backend databases in a User-Friendly manner.
The Customers are required to register on the server for getting access to the database and query result retrieval. Upon registration, each user has an account which is essentially the ‘view level’ for the customer. The account contains comprehensive information of the user entered during registration and permits the customer to get access to his past reservations, enquire about travel fare and availability of seats, make afresh reservations, update his account details, etc.
SESSION – MANAGEMENT
The data and the files present at the server are password locked. Hence, to gain access to them the user has to pass through the authentication process at ‘index.php’ / ‘adminauthenticate.php’, wherein a php session is initiated and the relevant session variables get initiated. If a client tries to access the locked files without starting a session, it is denied access and redirected to request for starting a session.
PERFORMANCE ANALYSIS
In this section, we evaluate the performance depending on the following variables to provide generic expressions rather than measure the times on a particular server-client-network pair
Database design in terms of the Normal forms the schemas conform
Number of joins, selections, projections, etc. for various forms of queries
Average access time over the internet
NOTES AND SUGGESTED FUTURE WORK
i. We have provided the ability where at max 3 people can be booked reservations for, this may not be desirable.
ii. We can extend it to provide multi-train service for connecting 2 stations, i.e. if there is no direct train between 2 stations, then we may use more than 1 train to book our reservations.
iii. The analysis assumes conservative and uniform spread of values, this may not hold and more sophisticated tools for estimation should be used.
iv. Greater information about the user can be stored and the user may be updated about changes in reservation status upon cancellations, via email