Desperately seeking help - db schema

From: piernik <copiernik_at_o2.pl>
Date: Tue, 26 Jul 2005 19:50:10 +0200
Message-ID: <dc5t3c$efa$1_at_ultra60.mat.uni.torun.pl>

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 Received on Tue Jul 26 2005 - 19:50:10 CEST