Analisis Laporan dan Buku Besar Pada E-commerce Dalam Penerapan Aplikasi Konsep Database Relasional : Studi Kasus Pada Aplikasi Shopee

Pinasthika Alya Disti; Muhammad Irwan Padli Nasution

doi:10.61722/jinu.v1i4.1894

Authors

Pinasthika Alya Disti Universitas Islam Negeri Sumatera Utara
Muhammad Irwan Padli Nasution Universitas Islam Negeri Sumatera Utara

DOI:

https://doi.org/10.61722/jinu.v1i4.1894

Keywords:

report analysis, ledger, e-commerce, relational database, Shopee application, data management

Abstract

This study aims to analyze the reports and ledgers on the Shopee e-commerce platform by applying the concept of a relational database. The main focus of this study is how the Shopee application manages user transaction data and compiles accurate and structured financial reports. The methodology used in this research includes data collection through documentation and system observation as well as interviews with relevant parties. The collected data were analyzed using a descriptive and quantitative approach to identify patterns and relationships among the data in the relational database system.The results of the study indicate that the application of the relational database concept in the Shopee application allows for more efficient and consistent data management. By using interconnected tables, the application can present detailed and accurate transaction information in the form of daily, monthly, and yearly reports. Additionally, the use of primary and foreign keys in the tables helps ensure data integrity and prevent redundancy. The ledgers generated from this system also show clear correlations between various accounts and transactions, facilitating the audit and financial examination process.Overall, this study underscores the importance of applying the relational database concept in e-commerce systems to improve data management accuracy and efficiency. These findings are expected to serve as a reference for other e-commerce application developers in optimizing their database systems

References

Ardiansyah, R., & Fauzi, M. A. (2018). “Implementasi Sistem Informasi Akuntansi Berbasis Database Relasional pada Perusahaan Dagang.” Jurnal Akuntansi dan Teknologi Informasi, 12(2), 45-58.

Basuki, T. (2017). “Perancangan Database Relasional untuk Sistem Informasi Penjualan Online.” Jurnal Teknologi Informasi dan Komputer, 4(3), 130-142.

Hartono, J. (2015). “Penggunaan Database Relasional dalam Pengelolaan Data Transaksi E-commerce.” Jurnal Sistem Informasi, 11(1), 21-34.

Ismail, R., & Yusra, Y. (2019). “Analisis Sistem Akuntansi Keuangan Berbasis Database Relasional pada UMKM.” Jurnal Akuntansi dan Bisnis, 14(1), 67-79.

Kurniawan, A., & Nugroho, S. (2016). “Desain dan Implementasi Database Relasional untuk Laporan Keuangan Perusahaan.” Jurnal Ilmu Komputer dan Informasi, 9(4), 150-163.

Mardiana, R., & Hidayat, T. (2017). “Pengembangan Sistem Informasi Akuntansi dengan Basis Data Relasional pada Perusahaan Jasa.” Jurnal Manajemen Teknologi, 16(2), 91-105.

Pratama, B., & Wijaya, E. (2018). “Evaluasi Penerapan Database Relasional pada Sistem Informasi Keuangan E-commerce.” Jurnal Teknologi Informasi dan Komunikasi, 7(1), 98-111.

Setiawan, D. (2017). “Optimalisasi Pengelolaan Data Transaksi E-commerce Menggunakan Database Relasional.” Jurnal Sistem Informasi Bisnis, 13(3), 177-189.

Susanto, A., & Riyadi, S. (2016). “Penerapan Konsep Database Relasional untuk Pengelolaan Laporan Keuangan Perusahaan.” Jurnal Teknologi dan Sistem Informasi, 5(2), 100-113.

Wibowo, T., & Andrianto, D. (2018). “Analisis dan Desain Basis Data Relasional untuk Sistem E-commerce.” Jurnal Rekayasa Sistem dan Teknologi Informasi, 12(2), 145-158.