I need to implement a simple quiz engine system which is somehow similar to the example explained in the ASP.NET website (for more information, please see this LINK). I have some quite difficult requirements that let me confused with the proper database design. I did one design and I am not sure about it. So I need your help and recommendation.
Example Question Types So Far:
Some requirement that I have to consider them:
My database design is as following:
asked Jul 16 '12 at 04:41 AM in Default
I think it looks OK. If I were doing it, I think I'd break apart the make-up of the quiz and the answers provided by the user, which I don't see in your design. But I like how you can use the same answers over & over for different questions. I would make sure you have an alternate key (a unique index) on the QuizContent table so that for any given quiz you don't get the same question & answer. Other than that, I think it looks OK.
answered Jul 16 '12 at 08:15 AM
Grant Fritchey ♦♦