I would like to design a simple questionnaire system, I don't know whether the following DB design is suitable, please give me some comments. THX!

--------------------------
Q: What pet do you like most?
A. Dog B. Cat C. Fish D. Rabbit

Q: What is your name?
A: Peter (input by the user)

--------------------------

Table 1: questionaire
questionaireID (int) [pk]
title varchar(100)

Table 2: questions
questionID (int) [pk]
questionaireID (int) [relationship with questionaire.questionaireID]
title varchar(255)

Table 3: answers
answerID (int) [pk]
questionID (int) [relationship with questions.questionID]
answer varchar(255)

Table 4: userAnswers
userAnswerID (int) [pk]
questionID int [relationship with questions.questionID]
answer varchar(255)
userID int
responseDate datetime

Why? Wouldn't it be easier to simply use an on line survey tool?

That way you don't need to code anything - just produce your questions, send out the survey to a bunch of email addresses then analyise the results on line. I did a quick google and came up with loads, here's just a few:

• survey monkey
• Zoomerang
• Survey gizmo

I'd suggest trying these out first and see if they meet your needs.

Mike

Oh~thx for your suggestion!
but it just a part of my system

Care to expand?
My initial impression was that it was just for homework

no, not my homework, actually, I'm self learning!
Just planning a survey system, since that I don't have much exp. in db design, I hope someone can comment my design.