Making a database

[xytech]

As a school project I have to create a web page, and one of the criteria is I have a database with 2 tables included. I'm mostly finished with the webpage, and just started learning databases. My problem is I'm making a guestbook database, and can't figure out how to get 2 tables involved. The common and obvious solution is just to put it all in a single table.

I'd love if someone a tad more experienced could give a suggestion to what I can put in each table when using a multi-table guestbook database.

[vesseblah]

Quick things that come to my mind

table 1:
primary key user id number, user name, user IP, user browser info, time last comment, time first comment, password

table 2:
primary key user id number, comment, time

And then display comments ordered by time. Basic quest book for comments isn't really good example for multi table project, but it's possible when you complicate things on purpose

[Rukentuts]

What are you using to interact with the database? JDBC?

[Badpaladin]

Vesseblah's idea is good - a "public view" a "private view" of a user is a good place to start. Has the benefit of reusing information, which is always fun.

[xytech]

Thanks for the suggestions, should come in handy ^^

It's just a locally hosted site and I'm using MySQL, XAMPP and dreamweaver. I didn't consider including them in the op as I was mainly just looking for a nice way to split it into 2 tables. Additional information would however be appreciated as well =)