Data modeling.

Question

Hello Team,

We have to conditionally show the questions based on the selection made.

E.X :

1. choices X,Y,X - Select one
2. choices A,B,C,D,E,F - Can select multiple

So depending upon #1 and #2 selection, we have to show the set of questions. Can someone give some idea how the data model should look like?

Thanks.

Answer 1

Let me know if the following tables satisfy your requirements:

• Table SelectionCategoryChoice (SelectionCategoryId [PK], Description)
• Table SecondChoices (SelectSecondChoiceId [PK], Description)
• Table Questionares (SelectionCategoryId [PK][FK, SelectSecondChoiceId [PK][FK], QuestionId [PK][FK])
• Table Questions (QuestionId [PK], question, CorrectPossibleAnswerId[FK])
• Table QuestionsPosiibleAnswers(QuestionId [PK][FK], PossibleAnswerId [PK][FK])
• PossibleAnswers(PossibleAnswerId [PK], AnswerDisplayed)

I added answers to questions also, despite you did no ask for them. Maybe you find it useful.

PK = Primary Key
FK = Foreign Key