Design of a Multi-Tenant Database for a Village Water Management Information System (Nusa Tirta)
Abstract
Village water management through BUMDes often faces challenges due to inefficiency resulting from the use of a recording system that is still manual, prone to errors and lacks transparency. This study aims to design a structured database for the "Nusa Tirta" system to support the digitization process of village clean water management. The research method used is a qualitative approach combining literature review and case study to test the Entity Relationship Diagram (ERD) structure through the application of a multi-tenant schema. The results indicate that the implementation of a shared schema architecture with the tenant_id attribute can securely maintain data separation between villages within a single integrated system. The use of integrity constraints and automatic relationships between tables also helps reduce the risk of human error and improves the accuracy of transaction data. Thus, this design can serve as the foundation for the development of a more flexible and secure village digital system that supports improvements in operational services in the future.
Downloads
References
D. Riswanda and A. T. Priandika, “ANALISIS DAN PERANCANGAN SISTEM INFORMASI MANAJEMEN PEMESANAN BARANG BERBASIS ONLINE,” vol. 2, no. 1, 2021.
K. K. Prima Eza Putri1, “PERANCANGAN DATA BASE SISTEM PEMBELAJARAN SEKOLAH DASAR MENGGUNAKAN ERD,” vol. 3, no. 5, pp. 314–326, 2025.
R. K. Sharma, “Multi-Tenant Architectures in Modern Cloud Computing: A Technical Deep Dive,” pp. 307–317, 2025.
S. Nugraha, D. W. Chandra, F. T. Informasi, U. Kristen, and S. Wacana, “Peningkatan Keamanan Database Pada Layanan Azure Melalui Metode Multi-Tenant Dengan Pendekatan Separate Database,” vol. 3, no. 6, pp. 233–240, 2023.
M. R. Akbar, A. Zurfadly, and M. Apriani, “PERANCANGAN DATABASE ELITE HOTEL TEMBILAHAN MENGGUNAKAN ERD (ENTITY RELATIONSHIP DIAGRAM),” vol. 3, no. 2, pp. 105–117, 2025.
S. K. Pippal, S. Kumar, and R. Rani, “Optimizing multi-tenant database architecture for efficient software as a service delivery,” vol. 22, no. 5, pp. 1128–1137, 2024, doi: 10.12928/TELKOMNIKA.v22i5.26385.
M. A. Al, M. Agreindra, S. April, and J. Barat, “SISTEM APLIKASI AIR BERSIH BERBASIS WEB : STUDI KASUS BUMDES KARYA MANDIRI DESA CIJEUNGJING Web-based Clean Water Application System : Case Study of BUMDes Karya Mandiri Cijeungjing Village”.
D. A. Armadi, E. Suganda, and U. Pakuan, “Digitalisasi pencatatan meter air dan penerimaan pembayaran sarana air bersih,” vol. 2, no. 1, pp. 55–62, 2022.
M. Rohman et al., “SISTEM INFORMASI PENCATATAN METER AIR BERBASIS WEB MENGGUNAKAN METODE WATERFALL,” vol. 9, no. 1, pp. 39–45, 2025.
R. A. Pradipta, P. B. Wintoro, D. Budiyanto, P. Studi, T. Informatika, and U. Lampung, “PERANCANGAN PEMODELAN BASIS DATA SISTEM INFORMASI SECARA KONSEPTUAL DAN LOGIKAL,” vol. 10, no. 2, 2022.
M. Franclin and B. Hakim, “APLIKASI PENGELOLAAN FOODCOURT MULTI-TENANT BERBASIS WEB PADA PT. PERKASA INTERNUSA MANDIRI BUILDING MANAGEMENT ALFA TOWER,” vol. 10, no. 1, pp. 1658–1664, 2026.
M. Khadik, G. W. Sasmito, and M. F. Hidayattullah, “Development of a Multi-Tenant System for Mosque Management Using a Decision Support System with the SAW Method,” 2025.
A. T. Rohman et al., “IMPLEMENTASI METODE SDLC DALAM TRANSFORMASI DESA MELALUI INOVASI APLIKASI PENGADUAN MASYARAKAT BERBASIS ANDROID,” vol. 12, no. 1, 2024.
R. Sabaruddin, S. Murni, and A. Apriyanti, “Penerapan Metode Waterfall Sisfo Buku Kas Digital Pada Bumdes Jaya Usaha,” vol. 5, no. 2, pp. 196–205, 2024.
P. Terpadu, K. Penengahan, M. Bisri, S. Karya, E. Sofyan, and A. Firma, “Integrasi Sistem Informasi Berbasis API untuk Mendukung Layanan Publik Terpadu di Desa Kelau, Kecamatan Penengahan, Kabupaten Lampung Selatan,” vol. 3, no. 1, pp. 5–18, 2025.
M. I. Mutahari, “ANALISIS KINERJA BASIS DATA TERDISTRIBUSI DALAM LINKUNGAN CLOUD COMPUTING,” vol. 3, pp. 1771–1782, 2024.
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
