Database

Hi

does anyone know the best way to go about creating a database application? I
know quite alot of sql and have access to an oracle server so if i could use
that then it would be great but i don't know if i can or how to do it

if anyone has any advice on what would be the best way to do this then i'd
be really grateful

Steve

re: Database

Peter,

"Peter Ellis" <pe012f2620@blueyonder.co.uk> wrote in message
news:v3qob.1979$4G2.381@news-binary.blueyonder.co.uk...[color=blue]
>
> Does anyone know the best way to go about creating a
> database application?
>
> I know quite alot of sql and have access to an Oracle server
> so if i could use that then it would be great but i don't know
> if i can or how to do it
>
> If anyone has any advice on what would be the best way to
> do this then i'd be really grateful
>[/color]

You could start by checking out the following tutorial:

http://java.sun.com/docs/books/tutorial/jdbc/index.html

I'm sure you'll find the required information, or suitable pointers to it,
there :)

I hope this helps.

Anthony Borla

re: Database

thanks for the help, thats exactly what i was after

"Anthony Borla" <ajborla@bigpond.com> wrote in message
news:rGLob.173732$bo1.36430@news-server.bigpond.net.au...[color=blue]
> Peter,
>
> "Peter Ellis" <pe012f2620@blueyonder.co.uk> wrote in message
> news:v3qob.1979$4G2.381@news-binary.blueyonder.co.uk...[color=green]
> >
> > Does anyone know the best way to go about creating a
> > database application?
> >
> > I know quite alot of sql and have access to an Oracle server
> > so if i could use that then it would be great but i don't know
> > if i can or how to do it
> >
> > If anyone has any advice on what would be the best way to
> > do this then i'd be really grateful
> >[/color]
>
> You could start by checking out the following tutorial:
>
> http://java.sun.com/docs/books/tutorial/jdbc/index.html
>
> I'm sure you'll find the required information, or suitable pointers to it,
> there :)
>
> I hope this helps.
>
> Anthony Borla
>
>[/color]

re: Database

To develop a database application, first thing first, you have to start with
the database design. That means what tables do you need? What fields do you
need? How are the tables related to each others (i.e. create the
Entity-Relationship Diagrams)? Create the schema in your Oracle database.
Draw up the data-flow diagrams and process-flow diagrams. Think about what
processings are needed, and what can be done in PL/SQL stored procedures.
So on and so on.

You see, the actual coding, whether it is in Java or C++ or whatever, should
be after all of the above are done. For a database application, the
database design is utmost important. I don't care how great your Java code
is, it is meaningless if the database tables are poorly designed.

Hope this helps.

simon.