Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    1

    Schema for questionaires/surveys

    Hi

    I'm designing a database app to store questionnaires/surveys/perfomance evaluations kind of things. I've been thinking about a design that would allow users to create new surveys and store the answers from other users.

    I wanted a design that allows multiple types of questions (e.g. multi choice, text answer, boolean, mulitpart answers etc..) . I suppose I could use an "Answers table" with a few text fields and use single table inheritance to interpret the fields.

    However, questionnaires etc must be a fairly common design pattern and there is probably a better way to do it, I wondered if someone could point me to some examples. Or at least give me a few names of patterns to go hunting for.


    Regards

    Caius

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by caiush
    questionnaires etc must be a fairly common design pattern and there is probably a better way to do it, I wondered if someone could point me to some examples.
    I don't suppose you tried searching the forum for the word "questionnaire"?

Posting Permissions

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