Thread: Java app with Netbeans and Derby database .. how to structure! :D

Hello!

This is my first post on this forum so please forgive me if I am a annoying and I have never ever studied databases :S so I may not make that much sense in terms of how I communicate my problem to you!

Right well... I am making this application that does a load of stuff but requires a database full of user info! So I followed this tutorial!
->> YouTube - Hibernate and Java

The tutorial shows you how to use netbeans and hibernate to create "employee" table, auto generate the getters and setters, populate some info into it and then run it ! specifically displaying the info you inputted!

I thought great! such progress in one sitting! I will easly be able to create my own now.

So yea, I planned out two tables for my test/digonostic server thing.

table 1 "Test info"
contains: Test number (int) , Test Descriptions (String)
with some kind of mini table hanging off that called "Test solutions"
that contains: Test result (String) , Test solution (String)
asssss there will be multiple types of results you can get from tests and different appropriate solutions.

Table 2 "User"
Contains: UserIndex(String) , Username(String) , Password(String)
with another mini table hanging off that called "user history"
that contains: Date(Date), TestType(String), Testnumber(int), TestResults(String).
because I want each user to have their own history.

But my problem appears now! I can create tables but I have no idea about how to create these unique tables that hang off other tables or even the terminology to allow me to google and look for similar tutorials!

If someone could explain to me roughly the steps, point me at a tutorial or give me a few key words I would be much appreciated!

Kind Regards,
Camel!

Thank you very much Copeg! this stuff worked a treat and I have a lovely fully functioning SQL Database hooked up to my java program!

My main mistake was using a convenience tool like hibernate which infact makes things more complicated for noobs! sadly at the time I didn't realize that it was one! Problem with being a noob is that you never do realize haha!