Assess students’ knowledge database formation Текст научной статьи по специальности «Строительство и архитектура»

т

tdshkent davlat «Актуальные вопросы развития инновационно-

rBAKISPOnTUNIVERSITETI 1 г „г Г1 ....

Ташкентский гесул; ровен™ информационных ТвХНОЛОГИИ НЭ транспорте» АВРИИТТ-2022

транспортный университет -г г -i г г

1-Республиканская научно-техническая конференция (Ташкент, 21-22 ноября 2022 года)

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 DOI: 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);

т

«Актуальные вопросы развития инновационно-

TOSHKCNT DAl/LAT

TRANSPORT UNIVEREITETI „ »nr-ini дтт

ташкенгсиий/мдамтмниый информационных технологии на транспорте» АВРИИТТ-2022

гранспортный униаерсиг* " ~ ~ г г

1-Республиканская научно-техническая конференция

(Ташкент, 21-22 ноября 2022 года)

IScience

iArenyA t»W cp*ce

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);

GROUPS

ground ~:e5ei name varchar(64)

QUESTIONS

id

quest or varchar[128) —

qjd ir:ege'

da;a__ odate" d3:e:ine

ANSWERS

id integer

it_ с integer

qu i id neger

quest onjd integer

option_ d ir:e=e'

is_ight integer

data_u :>dfted oaze: me

STU 3ENT

studentjd integer

group id nteger

га ne varchar(64)

evel_5ect on varchar(128)

datetirne

qUESTIONOrnONS d "eger

optior_tex: varchar^64)

question Jd nteger

rig"; integer

data_updated datetirne

USERS

.:ei_L iteger

na ne varchar(128)

userjtype iri^ge'

usernane varchar(54i

password varthar[64)

level_^ec:ic:r var:-ar[128)

integer

data_updated datetirne

HISTORY id

qu d student, с score

tota _score data_. adatec

integer ntege r ntege' i neger integer cd'.i'. me

SUBJECTS i- Djeci_ic Title

adated

user d

nteger varchar(123] date; Tie -tege'

Q U EZ_S7U D E NT_LIST id

uiz_id stL dertjd с ata_updated

=*c

"tege' ~;ege r ntege' cd'.i'. me

QLEZJST quiz_ с title

quez_options

userjd

data_updated

ntege r varchar(64) irt^gs' irtege' cate; me

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:

user_id name - user_type username

31 Abdullayev Eldor 2 eidor_abdullayev

S3 Shukurov Farrux Doniyorovich 1 shukurov_farrn>:

30 Xakimov Shoyadbek 2 xakimov_sh

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.

т

tdshkent davlat «Актуальные вопросы развития инновационно-

rBAKISPOnTUNIVERSITETI 1 г „г Г1 ....

ташкентский гесул; рственчый информационных технологии на транспорте» АВРИИТТ-2022

транспортный университет -г г -т г г

1-Республиканская научно-техническая конференция (Ташкент, 21-22 ноября 2022 года)

id quiz_id userjd score total_score date_updated student level_section title

S 28 35 6 10 2022-05-31 22:04:53 КОМ IL О VA FARAN GIZ AKMAL JONO VN A AT-33 Web texnologlyalar

7 28 37 6 10 2022-05-31 22:04:00 NABIYEV КОМ IL ULIJGBEKOVICH AT-33 Web texnologiyalari

14 28 38 4 10 2022-05-31 22:45:52 NIGMATULLAEVDAVRONBEK DILSHOD O'G'LI AT-33 Web texnologiyalari

15 28 62 5 10 2022-05-31 22:46:28 SHAKAROVA NODIRAIBROHIM QIZI AT-34 Web texnologlyalarl

13 28 54 6 10 2022-05-31 22:43:30 SHOMURODOV SHAXOBIDDIN ASOMIDDIN O'G'LI AT-34 Web texnologlyalarl

1G 28 55 9 10 2022-05-31 22:47:22 TOSH M AM ATOV JASURB EKABDULLAOG'LI AT-34 Web texnologlyalarl

17 28 57 4 10 2022-D5-31 22:4B:C1 UMIRZAQOV TEMURBEKOMONQUL O'G'LI AT-34 Web texnologiyalari

11 28 58 4 10 2022-05-31 22:42:03 VASIYEV NODIRJON DILSHOD O'G'LI AT-34 Web texnologlyalarl

9 28 59 8 10 2022-05-31 22:20:49 XOLMUROTOV ELBEKJON XUSNIDIN O'G'LI AT-34 Web texnologlyalarl

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.edu.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).

т

«Актуальные вопросы развития инновационно-

TOSHKCNT DAl/LAT

TRANSPORT UNIVEREITETI „ »nr-ini дтт

ташкенгсиий/мдамтмниый информационных технологии на транспорте» АВРИИТТ-2022

транспортный униаерсиг* " ~ ~ г г

1-Республиканская научно-техническая конференция

(Ташкент, 21-22 ноября 2022 года)

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.