April 11th, 2013, 02:39 AM
Buses Route Shedule
I have Following table in mysql
Station:=:= - name - latitude - longitude - is_terminal
Holiday - date - description
Route - Route_id := from_terminal : station_id - to_terminal : station_id
Route Detail := Route_id - Rdetail_id- Via places
Bus -Bus_id - BusName - BusType
How to Create Shedule for Bus Route And Viaplace
please run SHOW CREATE TABLE on all of these tables and post the reply along with what details you would like included in the bus schedule
please also note that your tables don't seem to have any times in them (e.g. the time each bus reaches/leaves a particular station, or the time it takes to get from one station to the next) unless you want to figure it out based on longitude/latitude and speed, this is something which you might also like to include in the schedule and have in the tables.
hey bobert, decent response, but just a wee bit late...
also, this question is obviously homework
so it's not likely the OP is still sitting there, waiting for an answer 6 weeks later
missed the datestamp.
just saw this when looking for something else