I hope  my post  won't offend people in this group,  as it's not my intention
to  annoy anyone or get someone do  my work for me.   I just  have nobody
else to ask for help :(

I'm studying informatics and I am to make a DB application.   I got a partner
and we agreed to write it in Java .  This way we can get finall marks also
from Java cours and save some work.   Unfortunately our good cooperation has
ended here.   My partner got focused on writing GUI. He don't want to listen
to my argument which is 'what we really need is a sensible schema of DB'.  He
finds what we have now is good.  He wants to work with this tables with java
language .  

Could someone take a look on this an write his opinion.  Maby he will listen to
you  :(

We do an application that allows to check bus connection from one city to
another.
The client should pick a city from a combo box.
He will receive  a name of line, the departure time and the fee.

-- name of  a city-to combobox and it's code -for use in select
create table Stations (
       StCode varchar2(4),
       StName nvarchar2(48),
       Primary key(StCode)
);

--distance between two cities
create table  Segments (
       StCode1 varchar2(4),
       StCode2          varchar2(4),
       Distance        number(5),
       Foreign key (StCode1) references Stations(StCode),
       Foreign key (StCode2) references Stations(StCode),
       Primary key (StCode1, StCode2)
);

-- full name of line -to print as a result, and it's code
create table Lines (
       LiCode varchar2(8),
       LiName nvarchar2(128),
       Primary key (LiCode)
);
--code of a line, code of a town on this line, number- tells which bus stop on
the line is the town( the first on this line, second... ).  On line A->B , A
is the first bus  stop and on A<-B B is the first bus stop. This is how we
distinguish directions- by the number of a bus stop.

create table StLines (
       LiCode varchar2(8),
       StCode varchar2(4),
       StNum number(2),
       Foreign Key (LiCode) references Lines(LiCode),
       Foreign Key (StCode) references Stations(StCode),
       Primary Key (LiCode, StCode)
);

He writes freakish loops in java to get information from this DB, and cout
distanece between towns ( to count fee).  We must set departure time but I
realy don't know in which table shuld I put it. It don't like the schema we
have now.

Has someone of you work on similar project?  I've been  looking in google for
3 days and I don't get interesting hit's. I wan't to correct this tables to
be able to work with them just with elegant SQL and Oracle , not with special
constuction in java.

Looking for critical voices
sad me