G
G
George2019-07-08 18:45:17
Database design
George, 2019-07-08 18:45:17

How to format a sql table correctly?

I want to develop a mini application for learning English.
Let's say there are two lists of English words (with translation). One list of words available for study, and the other - already passed. How to arrange sql table more rationally? I get it like this:
5d23642945b2c689491620.jpeg
the program will receive at once a field with open words (many words) and randomly select one that parses it into one task.
separate the word and the translation, and in brackets[2] the number 2 is the number of points for the correct answer.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-07-08
@hatepls

First, develop a model, and then a data structure, which you will design as tables.
Start modeling with the basic ones: user, word, translation, task, etc. Then from the relationship, for example, a word and its translation, user and task ...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question