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.
Create a separate answer sheet
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)