Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi I am building a survey DB, with three different quesionnaires, say A, B and C. What is the best way to model, have a table with survey names in (tblSurvey) on a one to many with all the questions (tblSurvey) or three different tables for the questions?

    Many thanks, Darren.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2009
    Location
    Rye, Victoria, Australia
    Posts
    150
    Thanks
    8
    Thanked 0 Times in 0 Posts
    It all depends on the structure of your surveys and the nature of the responses. If they are radically different from one another and include a lot of material written by the respondents, then you are probably better off with separate tables, because the processing will be different from each one. If however, they are multiple-choice tick-the-box style surveys then there is scope for building a generalised survey processor, because essentially you are only counting the responses and drawing conclusions from them. In the latter case you would have a parent table of all of the possible questions and a child table of all of the possible answers for each question. These can be edited at will to include new topics and lists of possible answers. Then you have another pair of tables. The parent lists your surveys and the child is the list of questions included in that survey. To create a new survey, you simply add the survey to the list and nominate the questions to be asked.

    I hope this is helpful.

Posting Permissions

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