Hiya
It would be much appreciated if any one cold help me solve this problem that I’ve got. First of all my problem is that I need to create an online journey planner for able and disabled persons to tourist attractions in London.
The user must specify what attraction they wish to visit, their starting station and if they are disabled on not. The system should then provide the following information: the start line to use, interchange stations (to change from line to another), the nearest end station on a particular line. I am going to be using servlets but I am a little confused on to how to go about doing the queries to get the correct information. I was thinking if the starting station and the destination station is on the same line then what the system could do is get there hop numbers and just minus one from the other to get the no of hops.
And my idea for the interchange is if the lines of the starting and destination stations do not match then find the next interchange, (an interchange is indicated in the STATION table by having ‘0’ under the hops column and ‘0’ under the line column). Oh if your confused with what hops means its basically the position of that station on that specific line. Once it finds the next interchange it looks to see if the destination stations line can be taken from that station ( this can looked up in the inter_line table). If it can then it can carry on till it finds its destination. I’m really confused on how to do these queries plz help!!!!!!!!!!!
Many thanks

The data model I have come up with so far is as follows:
CREATE TABLE LINE(
LINE_ID INTEGER(6) NOT NULL,
LINE_NAME VARCHAR(50),
PRIMARY KEY (LINE_ID) );

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.