Database design schema for a Quiz
I'm designing a simple quiz module with php and mysql backend and wanted to run by my design to see if there are any better suggestions.

- There can be multiple quizzes
- The questions can be multiple choice with one or more correct answers, fill in the blanks, or a paragraph description
- The same quiz can be taken multiple times. For example Quiz A - might have 100 questions, and every time a user wants to take a quiz - a random set of 10 questions will be picked.
- The user should be able to view all the quizzes he has taken along with this answers.

    

    
**Quiz**

quiz_id

name


**Question**

-question_id

-quiz_id

-question_desc

-question_type (**this is basically for me to decide whether to show radio buttons or checkboxes or text field or text area on the page**)


**Answer**

-answer_id

-question_id

-answer_desc (**this will store the multiple choice values**)

-is_correct

** **how and where should I store the answers typed by the user either in a text field or text area.**

I'm pretty confused about how to store the results each time the user takes a quiz. Like the same quiz can be taken multiple times - so they have to be grouped together. Is this structure good enough

**QuizResult**

-result_id

-quiz_id

-user_id

**QuizResultDetails**

-detail_id

-result_id

-question_id

-answer_id

Any suggestions are welcome.
Thanks a lot
Database design schema for a Quiz
===

I'm designing a simple quiz module with php and mysql backend and wanted to run by my design to see if there are any better suggestions.

- There can be multiple quizzes
- The questions can be multiple choice with one or more correct answers, fill in the blanks, or a paragraph description
- The same quiz can be taken multiple times. For example Quiz A - might have 100 questions, and every time a user wants to take a quiz - a random set of 10 questions will be picked.
- The user should be able to view all the quizzes he has taken along with this answers.

    

    
**Quiz**

quiz_id

name


**Question**

-question_id

-quiz_id

-question_desc

-question_type (**this is basically for me to decide whether to show radio buttons or checkboxes or text field or text area on the page**)


**Answer**

-answer_id

-question_id

-answer_desc (**this will store the multiple choice values**)

-is_correct

** **how and where should I store the answers typed by the user either in a text field or text area.**

I'm pretty confused about how to store the results each time the user takes a quiz. Like the same quiz can be taken multiple times - so they have to be grouped together. Is this structure good enough

**QuizResult**

-result_id

-quiz_id

-user_id

**QuizResultDetails**

-detail_id

-result_id

-question_id

-answer_id

Any suggestions are welcome.
Thanks a lot