I am designing tables for Questionnaire/Survey system. Most of the tables I already have are fairly typical (ie documents, questions, responses, choices, answers) but I came across an existing questionnaire that contains one section formatted as follows.
Code:
Stable (complete pre & post on all cases)
Pre Post
Date of Administration _______ _______
1. SSI
1. # positive influences __ __
2. # negative influences __ __
3. positive influences - negative influences __ __
Final "SSI" Score __ __
2. Deficits
1. Capacity... __ __
...etc.
There are 5 sub sections each with X number of questions under this Stable section. The actual "questions" above are in my question table but I am not sure what to do with the Pre/Post items and the SSI/Deficit items. I will need to find a suitable structure to satisfy queries such as
find all questionnaires whose Pre or Post 'Final SSI Score' = X or
find all questionnaires whose Pre '# positive influences' > Post '# of positive influences'
dBforums
>
Table design for questionnaire
08-05-09, 02:46
Linear Mode
