The theory of data normalization and its practical significance. (Based on the database of university students)
Keywords:
Normalizatsiya, ma’lumotlar bazasi, redundans, anomaliya, 1NF–3NF, avtomatlashtirilgan normallashtirish, RDBNorma, AdventureWorks.Abstract
In today's era of developing information technologies, the correct storage, processing and management of data is an important factor for any organization. Especially in higher education institutions, the annual growth of data on students, subjects, grades and the educational process requires a more thorough organization of the database structure. Data duplication, update anomalies and incorrect connections lead to slow system operation and an increase in the number of errors. This article analyzes the process of database normalization in the university student database and its practical effectiveness.
References
Taipalus, T. (2025). On the effects of logical database design on database size, query complexity, query performance, and energy consumption.
Dongare, Y. V., Dhabe, P. S., & Deshmukh, S. V. (2011). RDBNorma: A semi-automated tool for relational database schema normalization up to third normal form.
Scientific.Net (2018). Comparison between Normalized Databases Implemented with Different Database Systems. https://www.scientific.net/AMR.774-776.1827
Albarak, M., Alrazgan, M., & Bahsoon, R. (2017). Identifying and Managing Technical Debt in Database Normalization Using Machine Learning and Trade-off Analysis
Downloads
Published
How to Cite
License
Copyright (c) 2025 Shukrona Mahammadjonova, Sanjar Zokirov
This work is licensed under a Creative Commons Attribution 4.0 International License.
