How to do site testing?

Question

MySQL

Hello, I need to make a website with tests. With the ability to automatically calculate the score after solving all the tests. Naturally with the ability to add, edit and delete tests and answers for the admin. It seems that the task is quite clear. But for 2 days now I can’t even understand the algorithm of the site (how to add tests with questions and answers to the database, how to check for the correct answer and how to display the grade). I think that smart people will be able to tell me. I will be very glad.
Here is something like this:
https://englex.ru/your-level/placement/
https://iloveenglish.ru/tests/test_your_english_level

Answer 1

First, define in detail what you generally want and how it should look like. Learn about scoring algorithms. Then define all entities with attributes and relationships and design the base. Next, decide on the language in which you will do it, make an admin panel for creating and filling out tests, registering users, etc. And after all this, when everything previously done is polished during the implementation, you will already take care of the site.

Answer 2

Correctly wrote lubezniy , start with database design, I can advise a good book, examples are written there, author Seyed Tahaghoghi Manual on MySQL.