May I ask which language you will be using? asp, php, perl? The right way of doing this depends on the language you will be using.
As for the database, you might want to check out
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html. This will give you the basic idea of how the database should be laid out. It doesn't matter which database you are using, the concepts are all the same.