Simple survey database design [closed]

Question

I'm creating a survey for visitors of my event. However it's been a while since I created a database. So I need some help.

I found some solutions but they are way too extensive and that is something I don't need.

• Visitors need to stay anonymous but they can leave their email behind (seperate table Emails that isn't linked to anything atm).

• They have about 20 questions, some are open, some are one option(radio) and some are multiple options (checkboxes).

• The questions need to be reusable.

That's about it. I just don't know how to go beyond the many-to-many in the diagram.

Answer 1

Generally one row per respondent, and one column per question item. A battery of ten check-all-that-apply questions would thus get ten columns (either boolean or integer). Each open end gets a String field. During analysis, you can get fancy and aggregate questions, stack repeated batteries of questions, etc. in SAS, SPSS or Excel.