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?

9 Years
Discussion Span
Last Post by peter_budo

In your case there possibility of more then one answer

  1. 3 or 4 tables that will put together questionar
  2. 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
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.