search

Home  >  Q&A  >  body text

mysql - About database table structure design

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.

为情所困为情所困2767 days ago695

reply all(2)I'll reply

  • 伊谢尔伦

    伊谢尔伦2017-05-27 17:41:05

    Create a separate answer sheet

    reply
    0
  • 过去多啦不再A梦

    过去多啦不再A梦2017-05-27 17:41:05

    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)

    reply
    0
  • Cancelreply