Is the following database design proper for this Quiz Engine System?

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:

  • Multiple Choice (4 choices or 2 choices) with a Single Answer

  • Multiple Choice with Multiple Answer (like select the possible answers)

Some requirement that I have to consider them:

  1. the quiz may contain more than one question

  2. Many question may designed as a four multiple choice question, so I may have a possible answer (or choice) such as (All of the above) repeated or used in most of the questions. Therefore, I think my current design now will let me get a data redundancy regarding this requirement. What do you think? If this is bad, which design you recommend?

  3. Each question might have an answer explanation which be displayed to the user if he gets the wrong answer

  4. I may need to add an image to some of the questions and I don't know where I should put this from the database design.

My database design is as following:

enter image description here

more ▼

asked Jul 16, 2012 at 04:41 AM in Default

avatar image

0 5 5 6

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Jul 16, 2012 at 08:15 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

(comments are locked)
10|1200 characters needed characters left

You can think of "matching" as many questions with “multiple choice single answer”. Instead of radio button I would suggest a dropdown box. Layout would work better. For more information, check out http://www.keenesystems.com/Services/DatabaseDesign.aspx

more ▼

answered Feb 19, 2016 at 10:12 AM

avatar image

1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 16, 2012 at 04:41 AM

Seen: 5221 times

Last Updated: Feb 19, 2016 at 10:13 AM

Copyright 2018 Redgate Software. Privacy Policy