N
N
Nikita Verdinsky2020-12-27 17:01:42
Database design
Nikita Verdinsky, 2020-12-27 17:01:42

What should be changed/added/deleted in my database?

Good afternoon everyone. I am doing a graduation project "a program for teaching schoolchildren to program".
Question: what should be changed / added / deleted in my database so that it is compiled correctly?
And now a little about the program:
Features of the program:
1) the presence of lectures and tests on topics;
2) the possibility of gradual learning (1 topic (lecture and tests) per day), as well as independently on simulators (3 simulators in total

example of simulators
5fe891d2856e6568691129.png
5fe891de7bb56058444764.png
5fe891edbfe20203860264.png
choose the type of simulator and practice in it on past and current topics).
3) fixing classes on the main page (there will be indicated the passage of classes by day from the moment of registration to this day, more precisely, was the lesson or not on the selected day)
4) simulators have a time limit (each type of simulator has its own)
5) for the correct doing accrue tales

here are mine
tables:
1 user (id, name, password_hash (найти как делать хэш))
2 test (id, type, theme_id, timespan, mark)
3 question (id, theme_id, question_text, question_image)
4 answer (id, question_id, answer_text, isCorrect)
5 usertest (id, user_id, test_id, isPass)
6 schedule (id, user_id, theme_id, percentile
7 calendar (id, user_id, date, successful)
8 testlink (id, test_id, name, url)
9 theme (id, theme)
10 answerelement (id, question_id, text, number)


I would be grateful if you could help me create the database correctly.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dimonchik, 2020-12-27
@dimonchik2013

PAIDED
you do it, fill it in and start extracting, you look at something and fix it

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question