I am trying to normalize my database by following some of the forum threads on the topics. However, Im getting a little confused
I have created the following Questions Table (My answers will go in a seperate table)
QuestionID - PK
QuestionnaireTypeID - FK from tblQuestionnaireType
QtypeID - FK from tblQtype - listing Y = Yes/No, N = Numeric, T = Text
Qorder - The order the questions should appear, for that particular Quesitonnaire Type
Question - The actual text of the question
Some of my questions are in "Option Groups" - with for example 3 different options (radio buttons), or they will have a combo box with a number of different answers... How should I represent these in this structure?
Do I need to create a new table listing what the options are? (which seems messy - and doesnt seem to achieve the objectives of normalization), should I create a new column in my tblQuestions to group related questions together? (subgroups of questions...in which case I would need an additional subgroup "order" field? How would I deal with the mutually exclusive nature of these questions?) Does this make any sense??
Thanks for any help