Analisis Penerapan Normalisasi dan Mengurangi Redudansi Data pada Sistem Informasi Penjualan
Analysis of the Implementation of Normalization and Reducing Data Redundancy in Sales Information Systems
DOI:
https://doi.org/10.66886/aslamiah-jpesb.v4i2.307Keywords:
Database Normalization, Data Redundancy, Sales Information System, Third Normal Form, Relational DatabaseAbstract
This study aims to analyze the application of database normalization as a solution to reduce data redundancy in sales information systems. Good data design is the foundation of an efficient and reliable sales information system. Data redundancy is a fundamental problem often encountered in sales information systems that have not implemented database normalization optimally, resulting in data duplication, transaction anomalies, information incoherence, and wasted storage capacity. Data were obtained through literature studies and document analysis from various sources relevant to the theme of data normalization and data redundancy. The results of the analysis show that the gradual application of normalization from Unnormalized Form (UNF) to Third Normal Form (3NF) and Boyce-Codd Normal Form (BCNF) has been proven to consistently reduce data redundancy, eliminate anomalies, and increase the efficiency of sales information systems. These findings provide a practical contribution in the form of a guide to implementing normalization for sales information system developers.
Downloads
References
Apicella, A., Isgrò, F., Pollastro, A., & Prevete, R. (2023). On the Effects of Data Normalization for Domain Adaptation on EEG Data. Engineering Applications of Artificial Intelligence, 123, 106205. https://doi.org/10.1016/j.engappai.2023.106205
Asmarawati. (2025). Dari Manual ke Digital: Evolusi Akuntansi UMKM di Era Teknologi. Management Studies and Entrepreneurship Journal (MSEJ), 6(3), 3205–3214. https://doi.org/https://doi.org/10.37385/msej.v6i3.7801
Chaidir, M. , R. R., & Irawan, D. (2025). Transformasi Digital dalam Manajemen Keuangan: Studi Kasus pada UMKM Indonesia di Era Ekonomi Digital. Jurnal Mahasiswa Manajemen Dan Akuntansi, 4(1), 239–249. https://doi.org/https://doi.org/10.30640/jumma45.v4i1
Connolly, T. M., & Begg, C. E. (2019). Database systems: A practical Approach to Design, Implementation, and Management, 6th Edition (6th ed.). Pearson Education Limited.
Dina, D. F. M. (2024). Normalisasi Database Rancangan Sistem Penyewaan Buku Berbayar. Computing Insight : Journal of Computer Science, 4(1), 56–61. https://doi.org/10.30651/comp_insight.v4i1.15814
Efendy, Z. (2018). Normalization in Database Design. Jurnal CoreIT: Jurnal Hasil Penelitian Ilmu Komputer Dan Teknologi Informasi, 4(1), 34. https://doi.org/10.24014/coreit.v4i1.4382
Firdaus, J. B., Bonardo, R., Wibowo, I. I., Putra, R. A., & Renanti, M. D. (2025). Penerapan Normalisasi Basis Data pada Sistem E-Commerce Ratu Komputer. Jurnal Komputer Teknologi Informasi Sistem Informasi (JUKTISI), 4(3), 1574–1582. https://doi.org/10.62712/juktisi.v4i3.713
Gandung Triyono. (2011). Pertimbangan Melakukan Denormalisasi pada Model Basis Data Relasi. Jurnal Telematika MKOM, 3(2), 19–25. https://doi.org/https://doi.org/10.36080/telematikamkom.190
Hery Fadly, & Deddy Yusuf. (2024). Teknologi Media Digital Terhadap Produktifitas Serta Dampanya pada Bidang bisnis, dan Sosial budaya (Studi Kasus Desa Bone Kec. Bajeng Kab. Gowa Sulawesi Selatan). JUMABI: Jurnal Manajemen, Akuntansi Dan Bisnis, 2(1), 21–28. https://doi.org/10.56314/jumabi.v2i1.193
Hilmi, Razif, Rahmaniar Rahmaniar, & Fuadi. (2024). Digitalisasi Keuangan UMKM: Pelatihan Pengelolaan dan Akses Pembiayaan di Kota Lhokseumawe. 3(4), 189–192.
Indonesian Journal On Information System, I.-. (2019). Sistem Informasi Pengolahan Data Pembelian dan Penjualan pada Toko Koloncucu Ternate. https://doi.org/10.31219/osf.io/jcguh
Khomsi Pane, S. Y., Ramadhan, N. G., & Adhinata, F. D. (2022). Perancangan Basis Data Menggunakan Normalisasi Tabel pada Perusahaan Dagang Barokah Abadi. Journal of Dinda : Data Science, Information Technology, and Data Analytics, 2(2), 90–96. https://doi.org/10.20895/dinda.v2i2.563
Liu, T., Zhang, H., Long, H., Shi, J., & Yao, Y. (2022). Convolution Neural Network With Batch Normalization and Inception-Residual Modules for Android Malware Classification. Scientific Reports, 12(1), 13996. https://doi.org/10.1038/s41598-022-18402-6
M. Wali, & Efitra. (2023). Penerapan dan Implementasi Big Data di Berbagai Sektor. Son Pedia Publishing Indonesia.
Muhammad Faiz, Karunia Raharjo, Muhammad Agus, Muhammad Zidni Nur, Dicky Anggriawan Nugroho, & Imam Prayogo Pujiono. (2026). Optimalisasi Basis Data Sistem Keuangan UMKM Pizzaupps untuk Mengatasi Redudansi dan Anomali Data. Jurnal Rekayasa Informasi Swadharma (JRIS), 6(1), 120–133. https://doi.org/https://doi.org/10.56486/jris.vol6no1.1049
Munthe, A., M. Yarham, & Ridwana Siregar. (2023). Peranan Usaha Mikro Kecil Menengah terhadap Perekonomian Indonesia. Jurnal Ekonomi Bisnis, Manajemen Dan Akuntansi, 2(3), 593–614. https://doi.org/10.61930/jebmak.v2i3.321
Novi Algi Alviani, & Munawaroh Munawaroh. (2025). Transformasi Digital pada UMKM dalam Meningkatkan Daya Saing Pasar. MASMAN Master Manajemen, 3(1), 134–140. https://doi.org/10.59603/masman.v3i1.717
Rafianto, G., & Voutama, A. (2025). Implementasi Basis Data Terstruktur dengan Pencegahan SQL Injection pada Sistem Manajemen Penjualan. Jurnal Informatika Dan Teknik Elektro Terapan, 13(2). https://doi.org/10.23960/jitet.v13i2.6354
Romney, M. B., & Steinbart, P. J. (2021). Accounting Information Systems (15th ed.). Pearson.
Sopiah, S., & Afriady, A. (2022). Perancangan Aplikasi Sistem Informasi Akuntansi Laporan Keuangan Menggunakan Microsoft Access 2016. Indonesian Accounting Literacy Journal, 2(2), 468–483. https://doi.org/10.35313/ialj.v2i2.3203
Wati, K. lita, Rita, W., & Rahmah, W. (2025). Transformasi Manajemen Keuangan UMKM dalam Era Digital dan Ketidakpastian Ekonomi: Sebuah Eksplorasi Humanistik. RIGGS: Journal of Artificial Intelligence and Digital Business, 4(3), 566–575. https://doi.org/10.31004/riggs.v4i3.2025
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Bella Audya Manalu manalu, Muhammad Irwan Padli Nasution
This work is licensed under a Creative Commons Attribution 4.0 International License.
