appropriate schema modelling a dimensional model for questionnaires
1
vote
0
answers
29
views
I am designing a snowflake (star, constellation) schema to model a questionnaire enabling aggregation of questions.
1) A template can have multiple questionnaires.
2) A questionnaire can have only one template.
3) A questionnaire can have multiple questions (multiple choice, rating, text).
4) A question can have multiple answers.
A (questionnaire) template can be altered. Answers do not change.
What is an appropriate schema?
Asked by Bennimi
(165 rep)
Apr 11, 2025, 12:28 PM
Last activity: Apr 16, 2025, 01:39 PM
Last activity: Apr 16, 2025, 01:39 PM