mysql - About database table structure design
为情所困
为情所困 2017-05-27 17:39:05
0
2
673

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.

为情所困
为情所困

reply all(2)
伊谢尔伦

Create a separate answer sheet

过去多啦不再A梦

Question form:

Option table:

Question and option table (intermediate table):

Question and answer table (middle table):

This design can combine single selection, multiple selection, and judgment (can be regarded as single selection)

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template