creating Quiz DB, NOT mutliple choice.

[selvsagt]

Hi.

I am creating av quiz database, that are supposed to handle about 50 users.
It's about 50 questions, and the answers will be long, more than 255 signs.

I have som issues on how to go so far.
The quiz respondents will answer in a dap (or maybe Asp) web page on the intranet. The structure, shown below doestn seem right.

So far I got this:

tblQuiz
-------
quizID
Title
PassScore
introText

tblQuizPart
-----------
quizPartID
partName
sorting
quizID

tblQuizQuest
-------------
questionID
question
correctAnsw
maxPoints
sorting
quizPartID

tblQuizAnsw
--------------
answID
questionID
answer
username
timestamp
pointsGiven
sensured (yes/no)

======================

This is not a satisfying structure, but i'm not sure on where my mistake is.
Does anyone have a suggestion?

 

[The_Doc_Man]

Search this forum for topics such as "Questionnaire" because that topic has come up before. You can see a few discussions on different requirements. I know I've personally answered at least two like this in the last three months.