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

Looks like you've got it right.