#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0

    Question 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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2012
    Posts
    90
    Rep Power
    3
    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.
  4. #3
  5. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,179
    Rep Power
    4279
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2012
    Posts
    90
    Rep Power
    3
    missed the datestamp.
    just saw this when looking for something else

IMN logo majestic logo threadwatch logo seochat tools logo