Optimalisasi Desain Basis Data E-Commerce untuk Menjamin Integritas Data (Studi Kasus: Web E-Commerce Rie.charge)

Renanti, Medhanita Dewi
Pratini, Choirun Nisa Putri
Nisrina, Siti Nayla Alikha
Zaki, Farel Muhammad
Luthfiana, Daffa Erdiyan
Baruna A., Mochamad Emil

Jurnal Computer Science and Information Technology (CoSciTech)
Vol 6 No 3 (2025): Jurnal Computer Science and Information Technology (CoSciTech)

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.