Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

closed as off topic by mrdenny Oct 10 '12 at 23:17

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Care to share the answer you found? Thanks. – NoChance Aug 11 '12 at 22:14
I found it on stack overflow:… – reaper_unique Aug 13 '12 at 8:24
Good, thanks for sharing. – NoChance Aug 13 '12 at 8:43

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.

share|improve this answer
Thanks for the reply but I found my answer on stackoverflow :) – reaper_unique Jul 12 '12 at 17:52

Not the answer you're looking for? Browse other questions tagged or ask your own question.