Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    3

    simple questionnaire system

    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

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by btx
    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!
    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:I'd suggest trying these out first and see if they meet your needs.

    Mike

  3. #3
    Join Date
    Jun 2009
    Posts
    3
    Oh~thx for your suggestion!
    but it just a part of my system

    Quote Originally Posted by mike_bike_kite
    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:I'd suggest trying these out first and see if they meet your needs.

    Mike

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by btx
    but it just a part of my system

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

  5. #5
    Join Date
    Jun 2009
    Posts
    3
    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.



    Quote Originally Posted by mike_bike_kite

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •