Journal of Artificial Intelligence and Engineering Applications (JAIEA)
Vol. 5 No. 3 (2026): June 2026

Designing the Foundation of a Multi-Tenant and Surrogate Key-Based Nusa Praja Village Government System on the Nusa Eka Platform

Sri Rahayu (Universitas Amikom Purwokerto)
Aulia Hamdi (Unknown)
Lina Nur Afifah (Unknown)
Aulia Suryaning Tyas (Unknown)
Rizki Cahya Putri (Unknown)
Mayza Nurul Khasanatun Nisa (Unknown)
Intan Nur Sifa (Unknown)
Purnia Setiawati (Unknown)



Article Info

Publish Date
15 Jun 2026

Abstract

Village government administration in Indonesia is still largely manual, resulting in service inefficiencies and the potential loss of sensitive population data. The purpose of this research is to create the architectural foundation of a village government information system called NUSA PRAJA, which is part of the NUSAEKA multi-tenant Software as a Service (SaaS) platform. This research applies the Multi-Tenant Isolation concept to ensure data security and separation between villages, as well as the Surrogate Key concept to protect residents' National Identification Number (NIK) data from leaks. The research method used is Waterfall with the stages of requirements analysis, system architecture design, and database design. The results of the research are a multi-tenant system architecture design based on a shared database with tenant_id filters, an Entity Relationship Diagram (ERD) design with 14 main tables, and a flowchart design for three user roles. This project is expected to be a strong foundation for building a secure, scalable, and easy-to-use digital village system for village governments throughout Indonesia.

Copyrights © 2026






Journal Info

Abbrev

JAIEA

Publisher

Subject

Automotive Engineering Computer Science & IT Control & Systems Engineering

Description

The Journal of Artificial Intelligence and Engineering Applications (JAIEA) is a peer-reviewed journal. The JAIEA welcomes papers on broad aspects of Artificial Intelligence and Engineering which is an always hot topic to study, but not limited to, cognition and AI applications, engineering ...