View Single Post
Old Feb 6th, 2008, 8:34 PM   #2
Ghost
Man Bear Pig Hunter
 
Ghost's Avatar
 
Join Date: Jul 2005
Location: NorCal, USA
Posts: 295
Rep Power: 4 Ghost is on a distinguished road
Re: ASP.NET Survey Help

I'd store the questions seperate from the answers for starters.

tabQuestions - This will hold all of your questions, and maybe what test they belong to?
tabAnswers - This will Hold your Answers for your Questions tabQuestions
tabSurvey - This will hold the info of each Survery, basically it will tell you what question was asked and the answer to it.

Lets say tabQuestions looked like this:

ID, TestID, Question, Sort
1, 1, Are you at least 18 years of age?, 0
2, 1, How is your knowledge of computers?, 1


tabAnswers like this:

ID, QuestionID, Answer, Sort
1, 1, Yes, 0
2, 1, No, 1
3, 2, Excellent, 0
4, 2, Great, 1
5, 2, Average, 2
6, 2, Below Average, 3


tabSurvery like this:

ID, Survery, TestID, QuestionID, AnswerID
1, 1, 1, 1, 1
2, 1, 1, 2, 2


That should do I think.

Basically I said for the 1st Test you made, the first time anyone took it, I was 18 with great knowledge of computers.

Hope that helps you a little.
Ghost is offline   Reply With Quote