S
S
SkeW22022-02-13 19:11:57
Database design
SkeW2, 2022-02-13 19:11:57

What structure should be formed for storing test tasks?

How to form a structure for storing test tasks and design a web application to interact with this database? That is, some people write test tasks, others complete them and evaluate them depending on the correctness of the answers. Question types can be different, for example, "choose one correct answer", "choose several correct answers", "connect the left and right answer columns", "select a number from a range", etc. That is, it is not one common pattern.
Can make generic types, but we only have string(Text)? The question table consists of only three fields: Id, Type, Data. And depending on the type (Type), a simple json serialization / deserialization occurs. With such a structure, the question of storing answers arises, i.e.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artemy, 2022-03-04
@MetaAbstract

10 000 rub)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question