How to Design a Database for Surveys with Conditional Questions?

Conditional Questions in Survey Database Tables

In designing a survey database that accommodates conditional questions, you can opt for a schema including the following tables and relationships:

• Survey - Represents the survey itself.
• Question - Represents the individual questions within a survey, related to the Survey table with a one-to-many relationship.
• Answer - Stores user responses, related to the Question table with a one-to-many relationship.
• PossibleAnswers - Lists possible answer options for each question, related to the Question table with a one-to-many relationship.

To introduce conditional question functionality, consider these additional tables:

• QuestionCondition - Defines dependency rules between questions.
• AnswerDependency - Links questions to their conditional dependencies.

The QuestionCondition table holds the logical conditions for each question. For instance, a condition might state that Question B is only visible if the answer to Question A is "A." The AnswerDependency table establishes the connections between questions and their conditions.

Suppose you have two questions: "Do you buy cigarettes?" (Question A) and "What's your favorite cigarette brand?" (Question B). You can create a condition stating that Question B is only displayed if the answer to Question A is "Yes."

The AnswerDependency table would then link Question B to this condition, ensuring that it appears only to users who answered "Yes" to Question A.

The above is the detailed content of How to Design a Database for Surveys with Conditional Questions?. For more information, please follow other related articles on the PHP Chinese website!