«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
18
ASSESS STUDENTS
’ KNOWLEDGE DATABASE FORMATION
Tokhirov Ezozbek,
Associated professor, Tashkent State Transport University, Tashkent, Uzbekistan
etokhirov@yahoo.com
Xakimova Ezoza,
Master student, Tashkent State Transport University, Tashkent, Uzbekistan
https://doi.org/10.47689/978-9943-7818-0-1-v2-pp18-21
Abstract: This article aims to develop a database of student knowledge
assessment using modern software tools that are user-friendly and understandable
based on demand and supply. Also, the task of this database is to create a
convenient environment for evaluating students
’ knowledge and obtaining the
necessary information.
Keywords: Database, MySQL, PHP programming language.
Introduction
Currently, attention to the IT sector is growing in our country. Especially after
the coronavirus pandemic, this has increased significantly. The number of people
who are interested in programming and those who start learning it is increasing.
The number of educational centers providing education in various areas of IT is
increasing. The number of specialists in the IT market is also increasing
accordingly.
Among higher education institutions and professors, there are many
difficulties and time wasted in assessing students
’ knowledge. This database was
developed to find a solution to such problems, and users can access the database
through special logins and passwords given by the admin to teachers and students.
In the database, teachers place information about their subjects and tests for
intermediate evaluations and final evaluations, thereby saving time. Based on the
acquired knowledge and test results, the students are automatically evaluated in
the database and the results are obtained.
Main Body
Creating an infological model of the database
The first step in creating this project is to create an info model. The goal of
information modeling is to provide a natural way for people to describe and collect
information that can be formed in a database. Therefore, an effort is made to build
an infological model of data in accordance with natural language. Below is the SQL
query structure of the info model.
Creating an infographic model:
1. STUDENT (student_id, group_id, name, level_section, data_updated);
2. USERS (user_id, name, user_type, username, password, status,
data_updated);
3. GROUP (group_id, name);
4. SUBJECTS (subject_id, title, data_updated, user_id);
5. QUESTIONS (id, question, q_id, data_updated);
«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
19
6. QUESTION_OPTIONS
(id,
option_text,
question_id,
is_right,
data_updated);
7. QUIZ_STUDENT_LIST (id, quiz_id, student_id, data_updated);
8. QUIZ_LIST (quiz_id, title, quiz_options, user_id, data_updated);
9. ANSWERS (id, student_id, quiz_id, question_id, option_id, is_right,
data_updated);
10. HISTORY (id, quiz_id, student_id, score, total_score, data_updated);
Figure 1. ER-diagram of the student knowledge assessment database.
Application of the database of student knowledge assessment in
practice
Below we can see the database we created:
Figure 2. System user identification request window
in PHP MyAdmen environment.
The window of the list of users from the system, that is, the data of the
“Users” table, is given in Figure 2. In this window, users are sorted by id.
«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
20
Figure 3. PHP MyAdmen environment student web technology
test result request window.
In this window, the results were obtained based on the tests that the students
worked on.
Conclusion
The future role of this database is that it will create great opportunities and
ease in the assessment and monitoring of students
’ knowledge from any point in
real time by connecting to artificial intelligence in the formation of the database.
REFERENCE:
1. Aliev R., Tokhirov E., Aliev
М. The mathematical model of the sensor for
monitoring the state of the track section with current receivers// International
Journal of Recent Technology and Engineering (IJRTE). ISSN: 2277-3878,
Volume-8, Issue-5, January 2020. DOI: https://doi:10.35940/ijrte. E5936.018520
(Scopus; IF=0.158).
2. Aliev R., Tokhirov E., Aliev
М. Analysis, development of a model and an
algorithm in the concept of the growth of tone jointless rail circuits. Transportation
Research Procedia Volume 63, 2022, Pages 178-186. (Scopus; IF=0.158).
3. Aliev R., Tokhirov E., Aliev
М. Mathematical Model and Algorithm for
Determining the Optimal Parameters of Sensors Control the Approach of a Train to a
Crossing in Normal and Control Modes. AIP Conference Proceedings
Том 243216
June 2022. International Conference on Problems and Perspectives of Modern
Science, ICPPMS 2021 Tashkent 10 June 2021-11 June 202.1(Scopus; IF=0.158).
4.
М.М. Алиев,
Р.М. Алиев,
Э.Т. Тохиров,
Т.Р. Нурмухамедов.
Четырехполюсные рельсовые коэффициенты бесколлекторной гусеничной
цепи при наличии одного из концов гусеничной цепи изолирующего
соединения// Ташкентский Государственный Технический Университет
(1-
чорагида). Химическая технология. контроль и управление. 2019, №4-5
(88-89) https://uzjournals.ed
u.uz/ijctcm/vol2019/iss4/6 (05.00.00; №12).
5.
Р.М. Алиев,
Э.Т. Тохиров.
Определение
оптимальных
длин
бесстыковых рельсовых цепей на переездах и перегонах // Тошкент ахборот
технологиялари
университети
(1-чорагида).
Научно-технический
и
информационно-аналитический журнал ТУИТ 2019, №4 (52), (05.00.00; №31).
6. Aliev R., Tokhirov E., Aliev
М. Parameters of coefficients of the rail four-
pole of the jointless rail circuit according to locomotive receiver // Tashkent State
Technical University (1-choragida). Volume 2019 Issue 2. https://uzjournals.edu.uz/
btstu/vol2019/iss2/6, (05.00.00; №12).
«Актуальные вопросы развития инновационно-
информационных технологий на транспорте» АВРИИТТ-2022
I-
Республиканская научно-техническая конференция
(Ташкент, 21-22 ноября 2022 года)
21
7. Aliev R., Tokhirov E., Aliev
М., Tashmetov K. Research the Length of the
Braking Distance for Speed and High Speed Trains on Railway Sections //
International Journal of Advanced Trends in Computer Science and
Engineering. Volume 9, No.5, September
– October 2020, DOI: https://doi.org/
10.30534/ijatcse/2020/126952020 (Scopus; IF=9.84).
8. Aliev R., Tokhirov E., Aliev
М. Methodology for Determining the Optimal
Values of Resistance at the Ends of the Jointless Track Circuit with Considering
Twofold Shunting// International Journal of Emerging Trends in Engineering
Research, Volume 8. No. 9, September 2020. DOI: https://doi.org/10.30534/ijeter
/2020/25892020 (Scopus; IF=6.99).
9. Tokhirov E. Security Improvement Techniques at Railway Crossings of
Uzbekistan //
Интеллектуальный технологии на транспорте №1, 2020,
ISSN
2413-2527.
Петербургский государственный университет путей
сообщения Императора Александра 1. http://itt-pgups.ru/issue/viewIssue/194/86
(05.00.00; №110).
10. Aliev R., Tokhirov E., Aliev
М. Model Microprocessor Device of Four-Wire
Scheme of the Direction Change. German International Journal of Modern
Science. №11 2021.vol. 1. 30-32. DOI:10.24412/2701-8369-2021-11-1-30-32
(40 ResearchGate).
11. Aliev R.,
Tokhirov E.
Analysis
and
scientific
methodological
recommendations for reducing the delay on railway crossings. Interactive science.
– 2021. – № 5 (60). DOI 10.21661/r-554252 (40 ResearchGate).
12. Tokhirov E., Aliev R., Aliev
М. Devices to improve safety at level
crossings
// Технические науки: проблемы и решения: сб. ст. по материалам
XLI Международной научно-практической конференции «Технические науки:
проблемы и решения». – № 10(38). – М., Изд. «Интернаука», Москва-2020.
