Answer the question
In order to leave comments, you need to log in
Testing system. What is the best way to design a database?
I am making a fairly simple testing system: N questions with a certain number of answer options in each question.
Identification by login, then a list of questions is formed, the user marks the necessary ones, presses the send button and the data flies to the database. Then they are compared with the answers in the database and displayed on the screen. Everything.
Four types of questions:
1) One option is
selected 2) One or more answer options can be selected
3) An arbitrary answer in a text field
4) Combined (text field and checkboxes), but with one answer option
So. If the question type were only 1st (where there is one answer), then it would be something like this:
That is, the text of the user's response, recorded in the database, would be compared with the correct answer, after which it would be displayed on the TRUE / FALSE screen.
What about question types?
Answer the question
In order to leave comments, you need to log in
Four types of questions:
1) One option is
selected 2) One or more answer options can be selected
3) An arbitrary answer in a text field
4) Combined (text field and checkboxes), but with one answer option
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question