I am starting to work on a web page for a medical firm.
This webpage will include about ten different questionnaires for Patients.
The longest questionnaire has 160 questions, most of them having a yes/no answer.
I am not sure what the best way to go about this is.
The questionnaires are not likely to change.
So, should I a table for each questionnaire?
Or should I have a three tables: questionnaires, questions, and answers?
The latter is probably better for scalability, but the other on might be better to make data decisions with.
I am not sure if this was clear enough. Hopefully it was.
I appreciate any answers, tips, comments.