I want to make a test system, but I am currently encountering the problem of not knowing how to design the table.
If the questions are divided into single-choice, multiple-choice, judgment, short-answer, and fill-in-the-blank questions
For example, the option for a true-false question is the question itself
So use one table for all questions, and then distinguish them by type? So where do they put their correct answers?
Another option is how to make a table. There are single selection and multiple selection. It seems that the ideas are confusing. I hope experienced people can help sort it out.
单独建一个答案表
问题表:
![](http://img.php.cn/upload/image/000/000/000/c1e6db643bcef103a329f8ae96c1d2c9-0.png)
选项表:
![](http://img.php.cn/upload/image/000/000/000/d0c6f1c6255d67ca6f387f8bc23bbb1f-1.png)
问题与选项表(中间表):
![](http://img.php.cn/upload/image/000/000/000/d0c6f1c6255d67ca6f387f8bc23bbb1f-2.png)
问题与答案表(中间表):
![](http://img.php.cn/upload/image/000/000/000/206594af78107449cd3d34e4d26a184a-3.png)
该设计可以将单选,多选,判断(可视为单选)合在一起