Questionnaire database and preorder traversal tree alogorithm

Databases
1

HI all

I need to create a questionnaire dataabse.My questionnaire is dynamic.It’s having yes/no type questions.I need to implement the databse tables based on the ‘yes/no’

Which is the best method?

Can I use modified pre order traversal algorithm for this scenario?

please give me your suggestions ?

Thanks to all

2

i don’t see how or why your questions would be arranged hierarchically

3

If it is known that the questions will always be yes/no than its just a standard 1:m relationship.

questionnaire

  • id (pk)

questionnaire_question

  • id (pk)
  • questionnaire_id (fk)
  • question

questionnaire_answer

  • questionnaire_question_id (fk)
  • user_id (reference to user)
  • yes (0 or 1 value stored as TINYINT)
    pk(questionnaire_question_id,users_id)

for example