Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to create a database consisting of quiz questions with multiple choice answers. The questions are expected to have the following components:

  1. a question
  2. 4 or 5 multiple choice answers.
  3. an accompanying image for some questions (like math questions in SAT)

I was going to start creating the content in the form of a database but ended up coming across the idea that I could do it in a simpler form like XML and then simply convert the XML into a database. How feasible is this?

I also came across this question where the table is expected to have hardly any values (1 in 10,000), to which the topmost response suggests that using XML would not be feasible in that case since it would create redundant metadata.

But what about in this case where every field is expected to have a value?

share|improve this question
3  
In your mind, what is the value in using XML? –  billinkc Nov 6 '13 at 17:39
    
I expect the content (questions ) to be anywhere close to thousand or even more. Kinda like practice questions. And there may be at least 5-6 types of questions (sentence completion, algebra, etc.). So if it's in XML, I have a few people who I can explain the format of the XML to, and who would be creating the questions. The value in using XML is its ease of understanding and use - especially to those folks who don't know anything about XML. –  Zer0wolf Nov 6 '13 at 17:46
3  
And so when the math subject matter expert creates a question like Solve for x where x < 50 and x > 48 and doesn't understand why they have to actually write it as Solve for x where x %lt; 50 and x &gt; 48 that'll be easy, yeah? –  billinkc Nov 6 '13 at 17:51
3  
The point I'm trying to make is that data entry is/should be unrelated to storage mechanism. Using an XML store, in my mind, has specific use cases. Reading your question, it seems that a simple table would suffice which would allow a host of different entities to natively interface with it versus training people about how to write XML. –  billinkc Nov 6 '13 at 17:54
    
@billinkc Thanks for the advice. I see that using a relational database also makes sense here given that we would need to know which student has already taken a question from the set of questions. –  Zer0wolf Nov 6 '13 at 18:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.