AnsweredAssumed Answered

setting up a database to analyze survey results

Question asked by KristineGentry on May 12, 2011
Latest reply on May 12, 2011 by philmodjunk


setting up a database to analyze survey results


I am trying to set up a database to analyze the results of a survey that includes both open and closed ended questions.  I know I need a table for the survey questions, respondents, and answers.  I will also be reviewing the answers to the open ended questions and coding them.  Should the coded responses be on a separate table?

Also, the only data I have on the respondents is there userID number.  I do not have any data before conducting the survey about the respondents that will be useful for the survey.  Is there anything else I need in the respondent table other than the userID number?  And if there is no other data in that table, do I really need a separate table for respondents?