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?