MySQL Table Design for a Questionnaire

MySQL Table Design for a Questionnaire

I am fairly new to MySQL and have a project in which I need to design a database that will store responses from an online questionnaire. Reports will need to be written from the data. Does anyone have any tips on what type of fields to use? The questions will either have a Yes No answer, a choice of 4 options from very satisfied to very dis-satisfied or multipul choice. It's mainly the choice questions that I'm unsure on, as I will need to be able to product a report to show the percentage of satisfied customers. I know it's probably really basic, but I don't want to get it wrong.

How can you have boolean -datatype in VP-uml?


Are there other strategies available for auto-incrementing a primary key besides the default x+1?
Some of this depends on the design of the survey - is it single or multi-page; if multi-page, are you storing the data as the user moves from page to page, or just at the end, etc.

data transfer in vb6
I think the biggest issue is whether a single survey response is going to correspond to a single database row or whether a single survey response may be split across multiple rows.

To show correctly PRIMARY KEY in Postgres
Obviously the former is the way to go if at all possible.

To understand a statement in Postgres
Prefixing database table names
For the multi-choice questions specifically, I would use either INT or ENUM columns; determining the fraction of respondants answering in a particular way is a simple "SELECT ...

How to normalize an association between weekly participations and weekly questions?
GROUP BY " query.

What is the name of this diagram? [closed]


Have you explored the option of using something like SurveyMonkey for your questionnaire?. If that doesn't suit, there's a thread on MySQL's forum which may help: Database design for multiple choice questionnaire results?.

94 out of 100 based on 84 user ratings 784 reviews