Hello all!

I have found myself in a quandry.  While building our database, we
have discovered that our employees have to fill out a questionaire.
The previous db used had every question in the questionaire stored in
the same employee table.  Every question was therefore a new column in
that table.  This is, IMHO BAD stuff.  Some of the questions have
'sub-questions' that only need to be answerd if the 'parent' question
is answers in a specific way (such as YES).

The deal is that if I decide to split this up, so that I have:
* A questionaire table with columns: (questionaireID, questName)
* A quesitions table with columns: (questionID, questinaireID,
question, answerType)
* An asnwers table with columns: (answerID, questionID, answer)

This would force me to store all of my answers in 1 datatype.  All of
my answers would probably have to be some type of varchar(80) or
something like that.

Is there any other structure that you have used for this type of
problem?  How well did it scale?  Would it be possible to change
questions with your idea?

Thanks for your thoughts.

Dansan.