Thank you Kevin. Having an order number in the STATION_LINE table is a
very good idea instead of having the nextstation column. But there is
one problem. The records in the database could be inserted or
deleted. When we add a station for a particular line, we could have
inserted an order number of 25 if the two adjacent stations are 1 and
50 respectively.
Using this approach there will be limitations when we add more
stations or lines to the database. Is there any better option for
this?
Received on Mon Nov 07 2005 - 02:09:57 CST
