Implementasi Teknik Normalisasi Basis Data untuk Menghindari Redundansi Data pada Sistem Penjualan

Suriyati Suriyati; Heroe Santoso; Muhamad Azwar; Miftahul Madani; Ismarmiaty Ismarmiaty; Muhammad Innuddin; Mudawil Qulub; I Made Yadi Dharma; Muhamad Wisnu Alfiansyah

doi:10.52362/jisicom.v10i1.2354

Suriyati Suriyati Universitas Bumigora, Nusa Tenggara Barat
Heroe Santoso Universitas Bumigora, Nusa Tenggara Barat
Muhamad Azwar Universitas Bumigora, Nusa Tenggara Barat
Miftahul Madani Universitas Bumigora, Nusa Tenggara Barat
Ismarmiaty Ismarmiaty Universitas Bumigora, Nusa Tenggara Barat
Muhammad Innuddin Universitas Bumigora, Nusa Tenggara Barat
Mudawil Qulub Universitas Bumigora, Nusa Tenggara Barat
I Made Yadi Dharma Universitas Bumigora, Nusa Tenggara Barat
Muhamad Wisnu Alfiansyah Universitas Bumigora, Nusa Tenggara Barat

DOI: https://doi.org/10.52362/jisicom.v10i1.2354

Abstract

In today's digital era, efficient information management is key to a business's operational success. In the sales sector, high transaction volumes generate vast amounts of data daily. However, many sales systems still face a classic data architecture problem: data redundancy, or unnecessary duplication of information. Data redundancy is not simply a matter of inefficient storage; it directly impacts the emergence of data anomalies. When the same data is stored in multiple locations, the risk of information inconsistency during updates, deletions, and insertions is very high. Inconsistent data can mislead management in decision-making, for example, errors in inventory reports or financial recapitulations. The main objective of this research is to eliminate data redundancy and prevent anomalies in the sales system to ensure information integrity. Through systematic table organization, this research seeks to create a more efficient and accurate database architecture to support management decision-making. The method used is structured analysis through data decomposition stages. The process begins with collecting raw (unnormalized) transaction data, which is then processed through the 1NF, 2NF, and 3NF stages. The final stage involves validating the Create, Read, Update, and Delete (CRUD) functions to ensure the consistency of the new schema. The desired result is an optimal relational database schema, where data is logically distributed into specific, interconnected tables. This implementation will result in a lighter system, efficient storage usage, and error-free sales reporting.

Downloads

Download data is not yet available.

References

[1] M. Faiz, K. Raharjo, M. Agus, M. Z. Nur, D. A. Nugroho, dan I. P. Pujiono, “Optimalisasi Basis Data Sistem Keuangan UMKM Pizzaupps untuk Mengatasi Redudansi dan Anomali Data,” JRIS J. Rekayasa Inf. Swadharma, vol. 6, no. 1, 2026, doi: 10.56486/jris.vol6no1.1049.
[2] J. B. Firdaus, R. Bonardo, I. I. Wibowo, R. A. Putra, dan M. R. Dewi, “Penerapan Normalisasi Basis Data Pada Sistem E-Commerce Ratu Komputer,” J. Komput. Teknol. Inf. Sist. Komput., vol. 4, no. 3, hal. 1574–1582, 2026, doi: 10.62712/juktisi.v4i3.713.
[3] Z. R. Aqil, Mustofa Maulana Lingga Gumelar, I. R. Mukhlis, dan D. Hermansyah, “Rancang Bangun Basis Data dengan Studi Kasus Penjualan Hewan Ternak Melalui Aplikasi dengan ERD dan PDM,” J. Ilm. Comput. Insight, vol. 6, no. 1, hal. 51–61, 2024, doi: 10.30651/comp_insight.v6i1.21547.
[4] Nurhayati, M. I. Pertiwi, dan K. Maulana Rifky Kholilurrohman, Naraya Tamarussal, “Normalisasi Basis Data Sistem Deteksi Dini dan Konsultasi Komplikasi Kesehatan Masa Nifas,” Infokes J. Ilm. Rekam Medis Dan Inform. Kesehat., vol. 15, no. 2, hal. 139–145, 2025, doi: 10.47701/7e91s431.
[5] S. Mulyati, B. A. Sujatmoko, T. I. M. Wira, R. Afif, dan R. A. Pratama, “Normalisasi Database dan Migrasi Database untuk Memudahkan Manajemen Data,” Sebatik, vol. 22, no. 2, hal. 124–129, 2018, doi: 10.46984/sebatik.v22i2.319.
[6] M. Latief, “Pendekatan Database untuk Manajemen Data dalam Meningkatkan Kemampuan Mahasiswa Mengaplikasikan Konsep Basisdata,” Pros. APTEKINDO, hal. 231–238, 2010.
[7] G. Rafianto dan A. Voutama, “Implementasi Basis Data Terstruktur dengan Pencegahan SQL Injection pada Sistem Manajemen Penjualan,” JITET (Jurnal Inform. dan Tek. Elektro Ter., vol. 13, no. 2, 2025, doi: 10.23960/jitet.v13i2.6354.
[8] I. Mardiono, R. Fil’aini, dan F. S. Didin, “Perancangan Sistem Basis Data Offline Dokumen Akreditasi Program Studi,” J. OPSI, vol. 12, no. 2, 2019, doi: 10.31315/opsi.v12i2.3153.
[9] R. Aulia, D. G. A. Candra, dan A. Fauziyyah, “Analisa Perancangan Permodelan Basis Data pada Pengembangan System Informasi Pendaftaran Menggunakan Entity Relationship Diagram,” Invent. J. Inov. dan Tren Pendidik. Teknol. Inf., vol. 3, no. 3, hal. 100–111, 2025, doi: 10.37630/inventor.v3i3.2682.
[10] K. ’Afiifah, Z. F. Azzahra, dan A. D. Anggoro, “Analisis Teknik Entity-Relationship Diagram dalam Perancangan Database: Sebuah Literature Review,” INTECH (Informatika Dan Teknol., vol. 3, no. 2, hal. 18–22, 2022, doi: 10.54895/intech.v3i2.1682.
[11] M. R. Akbar, A. Zurfadly, dan M. Apriani, “Perancangan Database Elite Hotel Tembilahan Menggunakan ERD (Entity Relationship Diagram),” J. Sist. Inf., vol. 3, no. 2, hal. 105–117, 2025.
[12] S. KHOTIJAH, “Perancangan Database E-Learning Manajemen System untuk Pembelajaran pada Sekolah Menengah Pertama,” J. String, vol. 1, no. 1, hal. 65–73, 2016, doi: 10.30998/string.v1i1.970.
[13] Y. E. Sudiarti dan F. Wahab, “Perancangan Database Sistem Pengolahan Nilai Mahasiswa di Universitas Islam Indragiri Menggunakan ERD,” J. Sist. Inf., vol. 3, no. 2, hal. 97–104, 2025.