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?
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]