Design and Development of a Client-Server Architecture Database Information System for Inventory Management and Transaction Efficiency
Keywords:
Relational Database, Client-Server,, Bengkelqu-AI, Inventory, Transaction, MySQL, PHP.Abstract
Transaction management and inventory control in automotive Micro, Small, and Medium Enterprises (MSMEs) often rely on manual record-keeping systems, leading to stock data discrepancies, accounting vulnerabilities, and operational inefficiencies. This study aims to design and implement a Client-Server database information system named Bengkelqu-AI (Accounting & Inventory) at Bengkel Zulva Motor. Data collection was conducted through structured interviews with the business owner to identify business entity requirements and daily transaction workflows. The system was developed using the PHP programming language, MySQL DBMS, Apache web server via the XAMPP package, and Visual Studio Code. The relational database design for dbpenjualan yielded five integrated tables (tvendor, tcustomer, tbarang, tpembelian, and tbpenjualan). The implementation results demonstrate that the system successfully facilitates data processing through Create, Read, Update, and Delete (CRUD) operations, automated report generation, and database backup features in .sql format. The deployment of the Bengkelqu-AI system is proven to enhance transaction recording accuracy, minimize potential losses due to human error, and simplify real-time inventory monitoring.
Downloads
References
Apache Friends, 2021. XAMPP Apache + MariaDB + PHP + Perl. Available at: https://www.apachefriends.org/.
Dewi, I.A., Miftahuddin, Y., Fattah, M.A., Palenda, C.B. and Erawan, S.F., 2021. Point of sales system in InHome Café website using agile methodology. Journal of Innovation and Community Engagement, 1(1), pp.1–19.
Fathansyah, 2021. Basis Data. Edisi Revisi. Bandung: Informatika Bandung.
Fikri, M., Husain, B.M., Ndruru, I.P., Ndruru, F. dan Laiya, F., 2023. Rancang bangun sistem informasi persediaan barang berbasis website. Jurnal Teknologi Komputer dan Informasi (JURTIKOM), 3(1), pp.25–34.
Kadir, A., 2021. Konsep dan Tuntunan Praktis Basis Data. Yogyakarta: Andi Publisher.
Microsoft, 2021. Visual Studio Code: Code Editing. Redefined. Available at: https://code.visualstudio.com/.
Panchadria, P.A., Ferawati, F. dan Santoso, S., 2022. Toko sembako terintegrasi payment gateway Midtrans berbasis Android. Jurnal Tren Bisnis Global, 2(2), pp.45–53.
Putri, M.P., Nadeak, E., Malahayati, Rahmi, N., Rini, A., Sari, D.N., Kurniati, Kusmiati, H. dan Pratama, R.A.A., 2025. Sistem Manajemen Basis Data Menggunakan MySQL. Bandung: Widina Media Utama.
Putri, R.A. dan Raharjo, B., 2021. Sistem informasi penjualan berbasis web pada UMKM menggunakan PHP dan MySQL. Jurnal Sistem Informasi Indonesia, 6(2), pp.101–110.
Raharjo, B., 2022. Belajar Otodidak MySQL. Edisi Kedua. Bandung: Informatika.
Ricardo, H. dan Fajrin, A.A., 2022. Aplikasi sistem pakar mendeteksi kerusakan pada mesin Toyota 4A-FE berbasis web. Jurnal Comasie, 6(2), pp.11–19.
Sari, I.P., Syahputra, A., Zaky, N., Sibuea, R.U. dan Zakhir, Z., 2022. Perancangan sistem aplikasi penjualan dan layanan jasa laundry sepatu berbasis website. Blend Sains Jurnal Teknik, 1(1), pp.20–28.
Sari, N.D. dan Nugroho, H., 2022. Pengaruh sistem informasi penjualan online terhadap efisiensi operasional UMKM. Jurnal Ilmiah Informatika, 7(3), pp.90–99.
Utomo, A., Triayudi, A. dan Sholihati, I.D., 2021. Point of sales menggunakan metode agile development pada Bengkel Mandala Motor. Jurnal Teknologi Informasi, 5(1), pp.15–23.
Wulandari, A., Sagita, S.M. dan Dwitiyanti, N., 2021. Perancangan sistem informasi pelayanan jasa pada Bengkel Las Listrik Mitra Baja Abadi. Jurnal Riset dan Aplikasi Mahasiswa Informatika (JRAMI), 2(3), pp.412–419
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Journal of Information Technology, Computer Engineering and Artificial Intelligence (ITCEA)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
