Perancangan dan Implementasi Database Management System (DBMS) untuk E-Commerce PT XYZ

Abstract

PT XYZ menghadapi permasalahan proses transaksi manual yang inefisien. Untuk mengatasinya, PT XYZ memulai transformasi digital melalui pengembangan platform e-commerce berbasis B2B. Namun, pengembangan e-commerce ini memerlukan integrasi kompleks dengan berbagai sistem internal dan eksternal, serta menimbulkan kebutuhan mendesak akan perlindungan data sensitif perusahaan. Untuk menjawab tantangan tersebut, penelitian ini bertujuan mengembangkan basis data terpusat ternormalisasi serta mengimplementasikan Database Management System (DBMS) dengan Role-Based Access Control (RBAC) guna meningkatkan efisiensi, keamanan, dan integritas data. Menggunakan metode Database Life Cycle (DBLC), data dikumpulkan melalui studi literatur, observasi, wawancara, dan FGD. Hasil perancangan menghasilkan basis data MySQL terpusat dengan 55 tabel dan sistem RBAC yang terdefinisi. Implementasi dari perancangan ini berhasil mendukung operasional e-commerce serta mengamankan akses data pengguna, yang kemudian dikonfirmasi melalui pengujian komprehensif dengan SQL Query.

PT XYZ faced problems with inefficient manual transaction processes. To address this, PT XYZ initiated a digital transformation by developing a B2B e-commerce platform. However, the development of this e-commerce platform required complex integration with various internal and external systems, and created an urgent need for the protection of sensitive company data. To answer these challenges, this research aims to develop a centralized and normalized database and implement a Database Management System (DBMS) with Role-Based Access Control (RBAC) to improve data efficiency, security, and integrity. Using the Database Life Cycle (DBLC) method, data was collected through literature studies, observation, interviews, and Focus Group Discussions (FGD). The design results produced a centralized MySQL database with 55 tables and a defined RBAC system. The implementation of this design successfully supported e-commerce operations and secured user data access, which was then confirmed through comprehensive testing with SQL Query.