Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    11

    Database design question (bus schedules)

    Evening

    I was a for asp programmer and have been doing router/network installs for the past 3 years. My sql and database knowledge is limited but i need some help.

    I am working on a project that involves the bus system here in the city. I want to take these schedules "http://www.sorta.com/routes/Rt1Mar.pdf" http://www.sorta.com/schedules.html and make them searchable. The ultimate goal is to give current data of the next bus at "requested" stop. This is what i could come up with but i dont think this is right at all.

    route_tbl
    rid
    route_number

    stop_tbl
    stid
    rid
    stoplocation

    times_tbl
    tid
    stid
    times
    rid

    what do you think any suggestions would be much appricated.

    Thank you in advance

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Looks like you've got it right.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •