I\'m trying to design a db to store the timetable for 300 different bus routes, Each route has a different number of stops and different times for Monday-Friday, Saturday and Sunday.
I\'m looking at creating a time table solution. I have a task sheet that looks like Area 1 item 1 startTime endTime
I am going to create a little app using PHP that acts as a timetable. I am going to have it going from 9.00am to 5.00pm and through monday to friday.
I am trying to come up with the most efficient database as possible. My bus routes all have about 10 stops. The bus starts at number one until it reaches the 10th stop, then it comes back again. This
Hope you can help me out with this guys.It\'s not help with work -- it\'s for a charity of very hard working volunteers, who could really use a less confusing/annoying timetable system than what they