database design for question system

[chentiangemalc]

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?

[peter_budo]

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