Optimalisasi Desain Basis Data E-Commerce untuk Menjamin Integritas Data (Studi Kasus: Web E-Commerce Rie.charge)
DOI:
https://doi.org/10.37859/coscitech.v6i3.10643
Abstract
E-commerce platforms require accurate data management, but often face the challenge of data redundancy that threatens system integrity. This study aims to design an optimal database for the Rie.charge e-commerce case study. The research method used is the Database Life Cycle (DBLC) approach, with a focus on logical design. This process systematically applies normalization techniques to transform data from Unnormalized Form (UNF), through First Normal Form (1NF) and Second Normal Form (2NF) , to Third Normal Form (3NF). The results show that the 3NF design was successfully achieved, as evidenced by the redundancy rate analysis, which shows a significant and effective reduction in data redundancy. This optimal design has been proven to successfully eliminate data anomalies (insertion, update, deletion) and ultimately ensure data integrity.
Downloads
References
I. M. Sugi Ardana and Y. Mitha Djaksana, “Perancangan Basis Data Kawasan Suci Danau Tamblingan dengan Menerapkan Model Data Relasional,” Jurnal Syntax Admiration, vol. 4, no. 10, pp. 1598–1612, Oct. 2023, doi: 10.46799/jsa.v4i10.725.
D. Trihapningsari and M. A. Putri, “Perancangan Basis Data Sistem Reservasi Wisma Universitas Terbuka dengan Metode Database Life Cycle,” Jurnal Teknologi Sistem Informasi dan Aplikasi, vol. 7, no. 4, pp. 1638–1646, Oct. 2024, doi: 10.32493/jtsi.v7i4.45421.
S. Syaddam, Z. Febrianti, M. Christian, and H. Samuel, “PERANCANGAN DATABASE SISTEM KEARSIPAN DI SMP 13 NEGERI TARAKAN MENGGUNAKAN DBLC,” Jurnal Dialektika Informatika (Detika), vol. 5, no. 2, pp. 55–71, May 2025, doi: 10.24176/detika.v5i2.14715.
S. S. Wibagso and E. Lia, “Desain Model Database Layanan Panti Werdha dengan Menerapkan Metode Database Life Cycle,” Jurnal Teknik Informatika dan Sistem Informasi, vol. 6, no. 3, Dec. 2020, doi: 10.28932/jutisi.v6i3.3047.
S. M. Pulungan, R. Febrianti, T. Lestari, N. Gurning, and N. Fitriana, “Analisis Teknik Entity-Relationship Diagram Dalam Perancangan Database,” Jurnal Ekonomi Manajemen dan Bisnis (JEMB), vol. 1, no. 2, pp. 98–102, Feb. 2023, doi: 10.47233/jemb.v1i2.533.
S. Y. Khomsi Pane, N. G. Ramadhan, and F. D. Adhinata, “Perancangan Basis Data Menggunakan Normalisasi Tabel Pada Perusahaan Dagang Barokah Abadi,” Journal of Dinda : Data Science, Information Technology, and Data Analytics, vol. 2, no. 2, pp. 90–96, Jul. 2022, doi: 10.20895/dinda.v2i2.563.
C. Monicha and Y. Erwandi, “Analysis of Academic Database Design for SD Negeri 195 Lubuk Mumpo, North Bengkulu Regency,” Jurnal Media Computer Science, vol. 1, no. 1, Jan. 2022, doi: 10.37676/jmcs.v1i1.1916.
M. R. Kusnaidi, T. Gulo, and S. Aripin, “Penerapan Normalisasi Data Dalam Mengelompokkan Data Mahasiswa Dengan Menggunakan Metode K-Means Untuk Menentukan Prioritas Bantuan Uang Kuliah Tunggal,” Journal of Computer System and Informatics (JoSYC), vol. 3, no. 4, pp. 330–338, Sep. 2022, doi: 10.47065/josyc.v3i4.2112.
S. Yaremko and V. Novak, “System for Automating the Database Normalization Process,” NaUKMA Research Papers. Computer Science, vol. 7, pp. 11–17, May 2025, doi: 10.18523/2617-3808.2024.7.11-17.
Z. Wei and S. Link, “The Bounded Cardinality Normal Form for the Logical Design of Relational Database Schemata,” ACM Transactions on Database Systems, vol. 50, no. 4, pp. 1–45, Dec. 2025, doi: 10.1145/3744897.
A. Niamilah, A. A. Alfin, and I. Kurniasari, “Siklus Hidup Pengembangan Sistem Basis Data Pada Sistem Informasi Buku Tamu di Badan Pusat Statistik Kabupaten Kediri Menggunakan MySQL,” Jurnal Nasional Komputasi dan Teknologi Informasi (JNKTI), vol. 6, no. 1, pp. 115–121, Feb. 2023, doi: 10.32672/jnkti.v6i1.5830.
