I am currently working on my college project which is a bus timetable database in MYSQL. However, I am inexperienced in database design and am having problems.
I have the following entities
BUS, ROUTE, STOP, RUN, EXTRA_INFO
A bus must follow one route only. A route must consist of many stops. A stop may be used by many routes. A run may be subject to additional_info (eg not Sunday). A bus makes many runs each day. A bus may travel to or from town.
The database must be able to answer the following querie....
"What bus do I need to get from X lane to Y lane. I would like to travel on or after 10:00."
Another problem is that I'm not sure how the database will cope if X lane is after Y lane in the query. ie the user wants to travel away from town instead of into town.
Any advice or pointers to useful sites would be very-much appreciated.