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?