Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to store the bus route in the database ?

Re: How to store the bus route in the database ?

From: Eepē <eep_at_tnlcNOSPAM.com>
Date: Fri, 18 Oct 2002 20:17:14 GMT
Message-ID: <3DB06C54.14E06664@tnlcNOSPAM.com> 





I would make "bus" (id, bus), "stops" (id, stop), and "routes" (busID, stopID) tables.



Justin wrote:



> I have no idea how to store the information of different routes, there are

> many busStop, bus route

> 1 bus has many stops, and 1 stop may serve for many buses.

>

> How should i set up those tables?

Received on Fri Oct 18 2002 - 15:17:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US