PERANCANGAN DAN IMPLEMENTASI BASIS DATA RELASIONAL UNTUK SISTEM E-COMMERCE BERBASIS WEB

Authors

  • Uus Firdaus Universitas Djuanda Author
  • Ali Imannudin Universitas Djuanda Author
  • Meico Cahyo Adi Saputro Universitas Djuanda Author
  • Muhammad Bagas Atallah Universitas Djuanda Author
  • Muhammad Nabil Najmudin Universitas Djuanda Author
  • Abilpa Siti Kholifah Universitas Djuanda Author

Keywords:

Relational Database, E-Commerce, Database Design, ERD, MySQL.

Abstract

Database design is a crucial component in developing an e-commerce system, particularly to ensure consistent, secure, and efficient data management. A well-designed database is able to optimally support transaction processes, data storage, and integration between system components. This study discusses the design and implementation process of a relational database in a web-based e-commerce system using a needs analysis approach, Entity Relationship Diagram (ERD) modeling, normalization to the third form (Third Normal Form/3NF), and implementation using MySQL. The research method is carried out in stages to ensure the resulting database structure has good data integrity and consistency. The results of the study indicate that the designed database structure is able to reduce data redundancy, increase data integrity, and support transaction processes more efficiently. In addition, the resulting database structure is flexible so it can be developed to support more complex e-commerce features.

Downloads

Download data is not yet available.

References

Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). London: Pearson Education.

Dennis, A., Wixom, B. H., & Roth, R. M. (2015). Systems Analysis and Design (6th ed.). Hoboken, NJ: John Wiley & Sons.

Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th ed.). Boston: Pearson.

Hidayat, A., & Kurniawan, R. (2020). Perancangan basis data relasional pada sistem informasi penjualan berbasis web. Jurnal Teknologi Informasi dan Ilmu Komputer, 7(2), 215–224.

Karwin, B. (2010). SQL Antipatterns: Avoiding the Pitfalls of Database Programming. Boston: The Pragmatic Bookshelf.

Sari, D. P., & Nugroho, A. (2021). Implementasi database relasional untuk sistem e-commerce menggunakan MySQL. Jurnal Informatika dan Sistem Informasi, 5(1), 45–53.

Silberschatz, A., Korth, H. F., & Sudarshan, S. (2014). Database System Concepts (6th ed.). New York: McGraw-Hill.

Winand, M. (2012). SQL Performance Explained. Germany: Markus Winand.

Downloads

Published

2025-12-29

Issue

Vol. 1 No. 2 (2025): Desember

Section

Articles

License

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

How to Cite

PERANCANGAN DAN IMPLEMENTASI BASIS DATA RELASIONAL UNTUK SISTEM E-COMMERCE BERBASIS WEB (Uus Firdaus, Ali Imannudin, Meico Cahyo Adi Saputro, Muhammad Bagas Atallah, Muhammad Nabil Najmudin, & Abilpa Siti Kholifah, Trans.). (2025). SIGARUDA JOURNAL: Jurnal Ilmiah Bidang Sosial, Ekonomi, Budaya, Teknologi Dan Pendidikan, 1(2), 599-603. https://ejournal.sociovisionary.com/index.php/garudajournal/article/view/179

Most read articles by the same author(s)

Similar Articles

21-30 of 45

You may also start an advanced similarity search for this article.