Convenient database management system

I want to share my experience of the evolution of the use of database systems in the online language school GLASHA.

The school was formed in 2012 and at the beginning of its work all 12 students studied in it, so there were no problems with managing the schedule and payments. However, with the growth, development and emergence of new students, the question of choosing a database system became acute.

The task was to do:

1. a directory of all clients (students), keeping their full name, time zone, contact details and notes;
2. a similar list of teachers with the same information about them;
3. create a schedule of teachers in the same system;
4. make automatic generation of the class log;

   

5. track the history of classes;

   

6. accounting for finances both for writing off from the budgets of students and for paying teachers;

   

7. a scheme for tracking debtors among students;
8. a notebook for notes about some nuances of the lessons with pop-up reminders.

Oddly enough, all this complex reporting was done using Excel.

Moreover, spreadsheets made it possible to combine the budgets of students into one (if members of the same family are involved), combine the budgets of teachers (if they represent partner schools), enter different coefficients for paying teachers, set different prices for students, track bonuses and penalties for Skype school operators , see analytics on payments and lessons.

However, when the number of students increased to two hundred people, and the number of teachers to 75, then this functionality, made on the verge of Excel's capabilities, ceased to be convenient.

Firstly, the number of reports became insufficient for the control system, and secondly, the offline version required regular cleaning to maintain high speed. In addition, integration with bots was required to check free slots for teachers, check the balance at the request of students, send SMS about class cancellations, etc.

And over time, we created the Glasha web application, in fact, this ERP system, which allows you to plan the workload of teachers, maintain personal schedules for students, and also keep track of finances. Thanks to which various forms of reports became available, there was no need for a monthly base correction, it became possible to create a client’s personal account and upload homework, tests to test knowledge , link the schedule to the time zone of each student, etc.

I think that such a planning system would be useful for optimization in any kind of business.

Source: habr.com