Sample Header Ad - 728x90

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