Description

You will be given a server to create a teaching website.

You can choose MySQL.

A program/ an environment must be invented, where you can create tasks to teach MySQL.

The website must give exercise, the user must do these exercise and the system must be able to check if the exercise is done correctly:

- If yes, the system gives the next exercise and the user advances with the exercises.

- The creator, adds new exercises.

- When there are few hundred exercises, then we can say that there is a program learning the basics of MySQL.

- From the beginning multiple languages must be considered for explanations of the theory: tasks must have some texts, explaining theory.

Not each task but many of them. Also task must explain in text what it wants from trainee. So this text must be available in English, Russian and Armenian and other languages must be considered as well.

Details

The teaching website must be based on a well-known tutorial, for example on a W3 School.

User session starts by giving to each user:

· One of the first exercises must be creating a simple table

· Second can be finding the sum of values

· Type a request to find out the max number

· Then there are two tables

· Fourth exercise can be sorting the values, etc.

Little tasks, that start from 0 and end by turning the trainee into a professional.

· The trainees have their accounts.

· The exercises are the same for all trainees. But the system must know which trainee is at what position of progress.

· For each chapter of the tutorial, the creator invents the related exercises that the trainee will be able to do, given that the trainee did the previous exercises.

· The progress can be linear and the trainee will be allowed to do the next exercise only if all previous exercises are already done.

· The system must validate tasks in a same way, and automatically: the task is done correctly or wrongly.

On the example of one task:

The system has task number 5, which says here is a table with 10 random numbers, type a request to find out the mac number. How it must work?

- For this task, the system creates an empty DB for the current user.

- It creates a table and fulfills random numbers.

- It gives the user a prompt to access the DB.

- The user types his/her request.

- The system takes the request, executes, and compares the result with the right result.

- As the numbers are random, the result will be correct only if the request is correct.

- So the answer is yes or no. The task is done or is not done.

- If the task is done, the system suggests the next task.

- If not done, the system obliges the user to do the previous task.

- After each task the system deletes the temporary database to avoid a mess.

Each user for each task must have a brand new database. User does the exercise, the system checks the answer, yes or no, validates or not, then deletes all.

Each task is a template of a database with rules, what to compare and what to check.

The template is used for a creation of the temporary database at the moment of exercise of a user.

Tasks must be very simple to do and after 25 tasks the user must have already an idea what is MySQL.

Validation

1. Create the plan of the project with deadlines to provide to the management.

2. Create the project skeleton, then some hundred tasks, based on an existing tutorial.

3. The project is validated when the trainee passes the trainings via the teaching website.

Evaluated version

Evaluated version of the project, with listed project tasks, requirements and project skeleton is available under the following link: https://docs.switzernet.com/3/public/180509-mysql-exam-web-application/

* * *

4z.com