Monday, 15 August 2011

database design for online bus ticket booking with extra features -


I am trying to build an online bus ticket reservation system on a package base, where the ticket has some special features Tickets are included to see the place, just the ticket will be similar to all the passengers, but the price for other facilities may depend on passenger type (adult / hair / senior ...). There will be a table like the other_feature, passenger_type, feature_type, so I am confused how to add them to the reservation system, please appreciate any assistance. thank you in advanced!

my table structure

table reservation_ description

ID
travel_id
travel_detail_id
purchase_detail_id
reserved_date
seat_no
depature_date

table travel_details

id = bus_id
path_ id
depature_time
arrival_time
rentals
freq_detail_id

table routes

id


Distance for
Barrage

table freq_details

id
sun
mon
tue
wed
thu
fri
sat


No comments:

Post a Comment