Bạn nào có eproject thiet ke web sem 3 "Online Railway reservation system" giúp mình với hoac database cung duoc
xin moi nguoi giup dum.
Email: Psang15th5@gmail.com

Xem cái này có phải ko

http://www.mediafire.com/?lcz153priz3zcy1

http://prashish.wordpress.com/2010/12/27/online-railway-reservation-system-project/

Bạn nào có thề giúp mình về đề tài này không?

Giup thiết kế: DFD và Database

Railway Reservation & Management System

Indian Railways is one of the largest rail networks in world. Majority of people used to travel in train which is convenient and affordable means of transport. So keeping this in view, the reservation of railways is a most important task and it must be faster and efficient as the demand (travelers) is very high. In order to meet this demand, manual reservation is cumbersome and it requires an efficient program to implement the online reservation.

This Application enables us to choose the train even there is no necessary to fill a form at the railway reservation counter ,i.e. we can directly select from the choices provided for us with train numbers and their origin, departure time, destination & arrival time at that station and the class to travel in. Application gives us the final output as train ticket with the amount to be paid.

Customer Requirement Specification             

Railway Reservation System – Modules

Security module - Security modules include security features like user management and application level password management.

• Maintainuser master- Each user identified by the user name and user type. Onlyadmin user can create, edit user information.
• Passwordmust be alpha numeric.
• Whilecreating user system assign default password for the user
• Passwordof user are encrypted for the security purposes.
• Accesslevel and roles and privileges are set for different type of users.

Master Management modules- Master management module includes following sub modules.

• StationMaster – Every station isuniquely identified by system generated Station ID. It also includesstation code, station name and railway division name.
• TrainMaster – Every train uniquelyidentified by train no, it includes train name, train name, up/down status,route id., Number of coaches available for 3 tier AC, First Class, SleeperClass etc.
• TrainSchedule – It includes trainjourney details from start station to end station, all in between station,distances between 2 station, arrival and departure time.
• FareRule – It help to calculate fare by distance,support different type of fare calculation for different class like AC1,AC3 etc.
• CancellationFees Rule - It provide the masterdata for all ticket cancellation fees calculation.
• Reservationand Super Fast Fees – It provide themaster data for all ticket reservation fees calculation and super fastfees.
• DayMaster - Itincludes information of train schedule which days of the week train willrun.

Transaction Module - Transaction module includes following sub modules.

• Reservation– This module used to make reservation, it asks for input data like trainno, journey date, from station code, end station code. System has powerfulvalidation rule to check validation like journey date must be greater thansystem date, journey date must be within 90 days. Train should run for theselected day. Check for from station and to station. Seat availability,While saving the record system generate PRN no, seat no and coach no.Before save the system ask for final confirmation. System automaticallycalculates the fare and save the details.
• Cancellation– For cancellation of ticket it ask for PRN no, after entering the correctPRN no system check for validity of the PRN no, whether it alreadycancelled, journey date already expired. I it validate system display allthe details of the reservation. System automatically calculates thecancellation fees from the cancellation rule master. Before save therecord system ask for the confirmation.
• UpdateSeat no for unconfirmed passenger –It is schedule activity, system query for all cancelled ticket forparticular journey date and allocates all vacant seats to unconfirmedpassenger.
• DailyCash Transaction – It shows dailytransaction, like how much money received and how much money refund. Alldata can be exported to MS Excel for review and save in file system.

 

Query Module – Query module contains the following information:

 A powerful query module give on screen information for particular PRN NO, it shows all the reservation details and cancellation details, include current status for the seat no, coach no.

 

 

The tables required in the application are as follows:-

  a. Passenger detail

Field	Type	description
PNR no	numeric	Pnr no should be unique
Name	Varchar	Name of the passenger
age	numeric	Age of the pessenger
gender	char	Gender of the pessenger
Total Passenger	numeric	Number of pessenger
Date of Travel	Varchar	Date of travel
class	Var char	Class in which the passenger is travelling.
Train no	Varchar	Train no

b. Train details

Field	Type	description
Train no	numeric	Train no should be unique
Train Name	Varchar	Name of the train
Route from to	varchar	Route of the train
Departure time	Time	Time of the departure
No. of compartment	numeric	Total no of compartment available in the tain
1AC	numeric	Total no of compartment of 1AC
2AC	numeric	Total no of compartment of 2AC
3Ac	numeric	Total no of compartment of 3AC
Sleeper	numeric	Total no of compartment of Sleeper
General	numeric	Total no of compartment ofGeneral
	numeric

 

c. Login detail          

Field	Type	description
LOGIN_ID	AutoNumber	Autogenerated for partiualr user
LOGIN_NAME	varchar	Loginname
LOGIN_PASSWORD	varchar	Loginpassword

Fare Detail:-

 

Field	Type	description
distance	numeric	Distance between source and destination
Type of compartment	numeric	Type of compartment in which travelling
Type of train	varchar	Type of train in which travelling

 

Fare Detail:-

Note: student can add table if they require.