Test / Survey table design

hooks

Registered User.
Local time
Yesterday, 22:07
Joined
Aug 13, 2004
Messages
160
Hey all, I'm trying to design a Test / Survey database.

Please look at the .jpg attached or download the sample database.

I have looked at some previous survey/tests design posted on this forum and had a good table design based off of a Pat Hartman suggestion. Now i am wanting more out of the database and need more advanced options.

Here is what i am trying to do. When a user decides to make a new question for a test/survey they will have to choose what type of question the question will be. For example say the user wants to make a answer grid question. They would choose Answer Grid from the tblquestionstypes combobox. Then they would have the option of choosing a type of answer grid (Dual Scale, Rating Choice, Ranking Choice) from the tblQuestionOptionTypes combo box. Say the user chose Ranking Choice then they would be presented with a list of options for the Ranking Choice. For example 5 sets of rankings, 4 sets of rankings. 3 sets of rankings. (These are just coming off of the top of my head but i think you know what i mean.)

Question, Is this close to being correct. mind you i have just started this and am just throwing ideas around.
Where could i store the correct answer for each question. Sometimes there will be a answer and sometimes there will not be an answer due to the fact that it could be a test or a survey.

Any help or suggestions would be appreciated. Thanks
 

Attachments

  • Relations.jpg
    Relations.jpg
    88.4 KB · Views: 223
Last edited:
The only problem I see is with tblAnswers. It should have a two field primary key since it is a relation table. The primary key should be comprised of both AnswerID and QuestionID. The relationship between tblAnswers and tblQuestions needs to be removed and the relationship between tblAnswers and tblEnteredAnswers should be changed to be on both AnswerId and QuestionID.
 
Thanks a bunch Pat. You have always helped me in the past. I beleive this Survey/test database is going to kill me. The more i look into the different options the harder it is going to be.

Thanks Again
 
the relationship between tblAnswers and tblEnteredAnswers should be changed to be on both AnswerId and QuestionID.


How do i do this???
 
Never mind. I figured it out. Thanks again
 

Users who are viewing this thread

Back
Top Bottom