954,580 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

database design for question system

Hi There

Normally I'm not designing database but have the need to implement an internal questionaire system.

I'm wondering if anyone has examples of desigining a database for exams/etc? What I'm finding difficult is the need for multiple types of questions:

1. Multiple choice, one correct answer
2. Multiple choice, multiple correct answer
3. Text answer
4. Put items in the correct order answer

I've been trying to find an example of a database that stores different type of questions/answers or a book/website that shows how to create this type of system but yet to find one.

Is it best to create different tables for questions/answers? Different tables for different type of questions?

Or store the type of question and the answer in the one record?

chentiangemalc
Newbie Poster
1 post since Jul 2008
Reputation Points: 10
Solved Threads: 0
 

In your case there possibility of more then one answer 3 or 4 tables that will put together questionar
combination of database and coding coordination. Database can hold question with possible answer/s but you can also have field for page/coding action "create text field/area", "sort" that will trigger certain actions on your page

peter_budo
Code tags enforcer
Moderator
15,436 posts since Dec 2004
Reputation Points: 2,806
Solved Threads: 902
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You