I am designing a bus timetable using SQL. Each bus route has multiple stops, do I need a different t

Posted by Henry on Stack Overflow See other posts from Stack Overflow or by Henry
Published on 2010-03-23T21:27:02Z Indexed on 2010/03/23 21:43 UTC
Read the original article Hit count: 269

Filed under:

bus

|

timetable

|

sql

|

homework

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 cycle happens 3 times a day.

I am really stuck as to how I can efficiently generate the times for the buses and where I should store the stops. If I put all the stops in one field and the times in another, the database won't be very dynamic.

If I store all the stops one by one in a column and then the times in another column, there will be a lot of repeating happening further down as one stop has multiple times.

Maybe I am missing something, I've only just started learning SQL and this is a task we have been set.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about bus

NEC uPD720200 USB 3.0 not working on Ubuntu 12.04

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I've recently installed Ubuntu 12.04 64-bit on a HP Envy 15 1104tx. Most stuff appears to be working fine with the exception of the two USB3 ports (USB2 port works fine). I've read a lot of articles but so far have not been able to find a solution. I've tried adding 'pci=nomsi' to '/etc/default/grub'… >>> More
How do i mount my SD Card? I am using ubuntu 10.04

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
root@shobhit:/media# lsusb Bus 002 Device 017: ID 14cd:125c Super Top Bus 002 Device 003: ID 0c45:6421 Microdia Bus 002 Device 002: ID 8087:0020 Bus 002 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub Bus 001 Device 011: ID 413c:8160 Dell Computer Corp. Bus 001… >>> More
Enterprise Service Bus, .NET Service Bus, NServiceBus and the wheels on the bus...

as seen on Stack Overflow - Search for 'Stack Overflow'
Enterprise Service Bus (ESB), .NET Service Bus, NServiceBus, RhinoServiceBus, MassTransit and so on. I'm trying to understand what each of these technologies have in common or not in common. I attended Juval Löwy's presentation on the .NET Service Bus earlier today and he stated that the .NET Service… >>> More
Is there a Generic USB TouchScreen Driver 12.04?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Is there a Generic USB TouchScreen Driver 12.04? Device 03eb:201c I've been looking for 4 days solid (not very skilled) and can't find a solution. I have a generic tablet: C97- Atom N2600 9.7" 2GB 32GB Bluetooth WiFi WebCam Ext.3G Windows 7 Tablet PC Using 12.04 and cannot find a driver. I… >>> More
Why would 70-persistent-net.rules have no effect?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I've got a saucy server with a lot of NICs and they end up with weird names like "rename19". I know interface names can be changed by modifying the /etc/udev/rules.d/70-persistent-net.rules file. The first clue that something is wrong is that that file did not exist even though it's supposed to be… >>> More

Related posts about timetable

Creating a timetable using PHP

as seen on Stack Overflow - Search for 'Stack Overflow'
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 still deciding how i want the timetable to function but have this idea though, the user mouses over a section of the timetable, when the user… >>> More
Little Employee/Shift timetable HELP!!!

as seen on Stack Overflow - Search for 'Stack Overflow'
Morning Guys, I have the following tables: operator(ope_id, ope_name) ope_shift(ope_id, shift_id, shift_date) shift(shift_id, shift_start, shift_end) here is a better view of the data http://latinunit.net/emp_shift.txt here is the screenshot of a select statement to the tables http://img256… >>> More
SQL timetable for employee

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, i need to create an employee shift database. so i have 3 tables so far, employee, employee_shift, and shift im suppose to calculate how many shifts an employee has done at the end of the month, my question means, because a month has 30 days some have 28 and 31 days. this means i need to… >>> More
Fast programmatic compare of "timetable" data

as seen on Programmers - Search for 'Programmers'
Consider train timetable data, where each service (or "run") has a data structure as such: public class TimeTable { public int Id {get;set;} public List<Run> Runs {get;set;} } public class Run { public List<Stop> Stops {get;set;} public int RunId {get;set;} } public… >>> More
Informing Googlebot for deprecated pages

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I publish timetables in my website. For example last year I published Number 2 bus Summer 2013 timetable. I has pretty good ranking on Google SERPs for number 2 bus timetable But this year I added a new page with the name "Number 2 bus Summer 2014 timetable". When users search number 2 bus timetable… >>> More