=Paper=
{{Paper
|id=Vol-2525/paper1
|storemode=property
|title=Development of a prototype web-based search system for driving school jobs in scientific and educational activities
|pdfUrl=https://ceur-ws.org/Vol-2525/ITTCS-19_paper_2.pdf
|volume=Vol-2525
|authors=Anora Hamraeva,Olga Medvedeva,Svetlana Mustafina
|dblpUrl=https://dblp.org/rec/conf/ittcs/HamraevaMM19
}}
==Development of a prototype web-based search system for driving school jobs in scientific and educational activities==
https://ceur-ws.org/Vol-2525/ITTCS-19_paper_2.pdf
Development of a prototype web-based search system for driving
school jobs in scientific and educational activities *
Hamraeva Anora Shamsiddinovna Medvedeva Olga Anatolievna Mustafina Svetlana Anatol’evna
Kazan Federal University Kazan Federal University Bashkir State University
Kazan, Russia Kazan, Russia Ufa, Russia
anora.hamrayewa@gmail.com OAMedvedeva@kpfu.ru mustafina_sa@mail.ru
Abstract
The article shows the relevance of developing a web-
based driving school information system. The main
characteristics of the site, the requirements for it, the
tasks of its use in the educational process are
determined. The circle of site users is indicated, a form
for developing its information structure is proposed,
additional site information services aimed at openness
and improving the quality of education are discussed.
Introduction
Currently, cars have become publicly accessible vehicles, which entails a phenomenal increase in the relevance of
driving schools. To automate the work of companies use information systems to facilitate the workflow of
organizations. The relevance of such systems is determined by the presentation of large amounts of data in the form
of structured and ordered information.
Information system - an organizationally ordered set of documents or arrays of documents and information
technologies, including using computer technology and communications that implement information processes [1].
Modern information systems are impossible without the use of databases and DBMS, therefore the concept of an
information system is close in meaning to the term "database system". Ideal for the enterprise is a single system that
allows you to satisfy all the necessary needs of employees.
The purpose of the work is to develop a prototype of a web-based information system for accounting the work of a
driving school, which allows automating the work of the enterprise and facilitating the interaction between students
and school administrators.
Main part
In the work, an information system was developed to make the driving school management process more convenient
for customers and staff. This information system will allow interested users to enroll in courses, find out where the
branches of a driving school are, get information about fleets and leave feedback, and administrators can keep track
of students in a driving school, as well as accept new applications for training. To create the project on the server
side, we used: python / Django, django-rest-framework for providing api, on the client side, the React.js library was
used to create the visual interface, as well as nodejs and the create-react-app utility to run development server for
testing and debugging. PyCharm development environment was chosen as the implementation of the Driving
Schools information system. Advantages of this environment: smart auto-completion, automatic code generation,
automatic addition of necessary import operators, etc. PyCharm was chosen to implement the graphical interface.
For convenient navigation between files during development, the data was placed in folders based on their purpose.
*
Copyright © 2019 for this paper by its authors. Use permitted under Creative Commons License Attribution 4.0
International (CC BY 4.0).
Frontend is the client side of the user interface to the firmware of the service. In figure 1.1 you can see a description
of the functional user interface.
Figure 1.1. Frontend
The main code is located in the src folder, it contains the index.js file, figure 1.2. , which is the starting point of the
entire application.
Figure 1.2. Index.js file
Here, the router is connected to navigate through the components of the page and the main component of the App is
drawn onto the page, Figure 1.3. a), b).
Figure 1.3. Component App a)
Figure 1.3. Component App b)
Figure 1.4. Rendering the AboutUsPage Component
In figure 1.4. on the route about, the AboutUsPage component is drawn. The dashboard route is available only to
authorized users, otherwise the program will display page 404. Authorization is based on JWT tokens, which are
logged into localStorage and used to sign requests for confirmation of rights, this is implemented using the jios axios
library, this http client adds the Authorization header. Also in the components folder there is a layouts folder that
contains components that bump on each page, for example Navigation and Footer, the router at the address only
changes the component located between them. The page directory contains page components such as LoginPage,
IndexPage and others. An example of one of these pages is in Figure 1.5.
Figure 1.5. Page Component
To mark and position elements on the page, the bootstrap library [5] was used. Backend is a hardware-software part
of a service. The root directory contains the following main files and directories:
• apps - Applications in the Django framework, reusable components
• conf - Directory supporting basic routing, and project settings
• manage.py - Squeak for project management, application of migrations, etc.
• db.sqlite3 - Database
• media - Contains media files
The apps contains a single application - school figure 1.7.
Figure 1.7. School
Migrations - migration files for interacting with the database.
Models - Models (tables) of the database. In figure 1.8.
Figure 1.8. Database Models (Tables)
Serializers contains classes for serializing records from a database in json, for subsequent submission.
Figure 1.9.Token
In figure 1.9. the token from the djangorestframework_simplejwt library is redefined. Email address and username
are added. In figure 1.10. by post request to the server from the client part at the address orders. The OrderAPIView
view is called. Where is the entry in the orders table about the enrollment of a new student created? The name,
category and instructor number are transmitted in the post request.
Figure 1.10. client part at orders
System Information Storage Design. To store the necessary information in the system, the SQLite database [4] was
used. The system consists of the following tables (figure 1.11):
• User profile - name, username and password;
• Car - car model, instructor and color;
• Application for training - name, category of rights and instructor;
• Application for consultation - phone number and name;
• Reviews - text, username.
Figure 1.11. ER database diagram.
During testing, the method of 50 test cases was applied, which checks the operation of the site. Its essence is that it
checks the operation of the main functions of the site and its correct display in all current browsers.
Conclusion
Information systems allow you to automate the work of companies, so their development is of high practical
importance in the modern world. In order to speed up and increase the efficiency of the consultation process and
application for training, the task was to develop a new information system for use by administrators and a user of a
driving school. In the course of the work, an information system for a driving school was developed. This system
will automate the work of a driving school and facilitate the process of interaction between the user and the
administrator of the driving school. In the course of the work, a study of the subject area was carried out, the actors
were identified, a graphical interface was designed and a prototype of the information system was developed.
Acknowledgements
The authors express their gratitude and appreciation to the organizers of the conference of the Ural Federal
University and Innopolis University for their help and support in preparing the article.
References
1. Architecture and design of software systems: monograph / S.V. Nazarov. - 2nd ed., Revised. and add. - M.:
INFRA-M, 2018. - 374 p.
2. Djangoproject Guide [Electronic Resource] - Access Mode: URL: https://www.djangoproject.com/
3. Python Guide [Electronic resource] - Access mode: URL: https://www.python.org/
4. Gagarina L.G. Introduction to software architecture: textbook. allowance / L.G. Gagarina, A.R. Fedorov, P.A.
Fedorov. - M.: FORUM: INFRA-M, 2017. - 320 p.
5. GOST 19.201-1978. Technical task. Requirements for the content and design.; Enter 01-01-1990. - M.:
Publishing house of standards, 1989. - 13 p.
6. GOST 34.601-1990. Automated systems. Stages of creation.; Enter 01-01-1992. - M.: Publishing house of
standards, 1990. - 6 p.
7. Introduction to software engineering: Textbook / V.A. Antipov, A.A. Bubnov, A.N. Pylkin, V.K. Stolchnev. - M.:
COURSE: INFRA-M, 2017. - 336 p.
8. Matorin S. I. Information systems: Training and practical guide / S.I. Matorin, O.A. Zimovets – Belgorod:
Publishing House of Belgorod State University, 2012.
9. Official documentation about Getbootstrap [Electronic resource] - Access mode: URL: https://getbootstrap.com/
(03/15/2019).
10. Official JavaScript library documentation [Electronic resource] - Access mode: URL: https://reactjs.org/
(03/29/2019).
11. Andrianova A.A., Mukhtarova T.M., Rubtsova R.G. Laboratory workshop on the course 'Database
Technologies': Textbook / A.A. Andrianova, T.M. Mukhtarova, R.G. Rubtsova. - Kazan: KFU, 2016. - 97 p.
12. SQlite Database Guide [Electronic resource] - Access mode: URL: https://www.sqlite.org/ (12.28.2018).