Simple survey database design
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 to 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 you see below.
How do I go from here? An Answers table needs to have a relationship with? The Surveys_have_Questions, or with Questions?
Edit:
As the answer in the following links mentions, most surveys are based upon classic design patterns. Mine is one of those surveys. More info in the link below: What mysql database tables and relationships would support a Q&A survey with conditional questions?
I would probably model the event of a user taking a survey, perhaps a table called "User_Answer_Session", which has links to the survey and the user; and then "User_Answers", which are tied to the session and the question and include the actual blob of the answer. How exactly I modeled the answers would depend on a few things (mainly how robustly I wanted to be able to look them up). For instance, do I want to be able to index multiple-choice answers for extremely rapid reporting? If so, then you need to model for that. This may include creating a "Question_Options" table, which is a one-to-many between a question and the available options...
This should get you thinking along a good path. :-)
- is there any way to check with cumulative way to get month based on the amount fields
- How to compare using bcrypt in a db query using node.js and express
- SQL query to check if a name begins and ends with a vowel
- MySQL JSON_OBJECT() datetime format
- Why is MySQL Sorting by mp.id in This Query Execution Plan?
- PHPExcel download not working properly
- brew start and brew restart wont start service
- MySqlCommand().ExecuteReader().GetString() does not work
- how to sum rows together but also leave the original rows in the results?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
- SQL filter for same values in different columns
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- MySQL - Does the READ UNCOMMITTED isolation level use locks?
- convert mysql timestamp into actual date and time?
- Optimize order by rand()
- Change max_heap_table_size value?
- wordpress - Big post IDs, is it Okay in the future?
- Incorrect string value error for unconventional characters
- Cannot open include file: 'mysql.h': No such file or directory
- How do I connect Biostar V1.8 Suprema to MySQL?
- How to convert a string to date in MySQL?
- Duplicate records in MySQL. EXISTS check for the same data not working properly?
- How to define a custom ORDER BY order in mySQL
- On duplicate key ignore?
- How to fix MySQL providing duplicates that do not exist?
- What's the best MySQL alternative to dual?
- mysql SELECT issue with HAVING and/or WHERE
- How can I connect an externally hosted MySQL database to BigQuery?
- DBeaver error resolving maven dependencies