• Survey Modelling

    • This topic has 1 reply, 2 voices, and was last updated 15 years ago.
    Author
    Topic
    #468661

    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.

    Viewing 0 reply threads
    Author
    Replies
    • #1222006

      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.

    Viewing 0 reply threads
    Reply To: Survey Modelling

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: