Design of a Web-Based Village Population Data Processing Information System: A Case Study of Tanah Merah Village Office, Pasir Penyu District

Farida Gultom; Adi Kurniawan; Sastra Wandi Nduru

doi:10.69693/jesa.v3i2.56

Authors

Farida Gultom Universitas Efarina
Adi Kurniawan Universitas Efarina
Sastra Wandi Nduru Universitas Efarina

DOI:

https://doi.org/10.69693/jesa.v3i2.56

Keywords:

Population Data, Village Administration, Web Information System, Waterfall Model, Black-Box Testing

Abstract

Population administration at the Tanah Merah Village Office, Pasir Penyu District, previously relied on conventional records that created duplicate data, inconsistent information, slow retrieval, and delayed report preparation. This study designed and implemented a web-based population data processing information system using observation, interviews, literature review, and the waterfall development model. Requirements were translated into use-case, activity, and class diagrams and a MySQL database. The implemented PHP-based system provides administrator authentication, user management, population and destination records, move-out requests, online birth-certificate registration, death-certificate registration, monitoring, document-completeness checks, and service outputs. Black-box testing covered seven navigation and data-management scenarios. All seven scenarios produced the expected results, yielding a 100% pass rate within the documented test scope. The system centralizes village records, reduces dependence on physical archives, and supports faster retrieval and reporting. Further work should evaluate usability, security, data validation, interoperability with higher-level civil-registration services, and operational performance after deployment.

Downloads

Download data is not yet available.

References

[1] Z. Rachmat, S. Wahyuddin, and A. Irfan, “Rancang bangun sistem informasi pengelolaan data penduduk berbasis web pada Desa Palangiseng Kabupaten Soppeng,” vol. 12, pp. 1022-1031, 2023.

[2] K. R. Dikana, M. Utami, and S. A. Saputera, “Perancangan sistem informasi pendataan penduduk berbasis web di Desa Tanjung Tawang Kecamatan Muara Pinang,” vol. 4, pp. 80-91, 2022.

[3] N. Oktober, M. Lende, H. H. Ratu, and D. R. Sabawaly, “Perancangan sistem pengolahan data penduduk di Desa Kadi berbasis web,” 2025.

[4] A. Arfian, “Implementasi aplikasi sistem demografi berbasis green computing dalam pengelolaan data kependudukan Desa Kertarahayu,” vol. 1, pp. 57-62, 2018.

[5] R. S. Pressman and B. R. Maxim, Software Engineering: A Practitioner's Approach, 9th ed. New York, NY, USA: McGraw-Hill, 2020.

[6] I. Sommerville, Software Engineering, 10th ed. Boston, MA, USA: Pearson, 2016.

[7] S. Narulita, A. Nugroho, and M. Z. Abdillah, “Diagram Unified Modelling Language untuk perancangan sistem informasi manajemen penelitian dan pengabdian masyarakat,” pp. 244-256, 2024.

[8] S. W. Ramdany, S. A. Kaidar, B. Aguchino, C. Amelia, and A. Putri, “Penerapan UML class diagram dalam perancangan sistem informasi perpustakaan berbasis web,” vol. 5, no. 1.

[9] G. Booch, J. Rumbaugh, and I. Jacobson, The Unified Modeling Language User Guide, 2nd ed. Boston, MA, USA: Addison-Wesley, 2005.

[10] Oracle Corporation, “MySQL 8.4 reference manual,” 2026. [Online]. Available: https://dev.mysql.com/doc/refman/8.4/en/. Accessed: Aug. 24, 2026.

[11] E. Siswanto, E. S. Wibawa, and Z. Mustofa, “Implementasi aplikasi sistem peramalan persediaan barang menggunakan metode single moving average berbasis web,” vol. 14, no. 2, pp. 224-233, 2021.

[12] H. Nurfaizal, A. Efendi, and D. E. Prasetyo, “Pemanfaatan Bootstrap sebagai framework desain responsif untuk meningkatkan keterampilan pemrograman web,” vol. 3, no. 1, pp. 175-182, 2025.

[13] B. Beizer, Black-Box Testing: Techniques for Functional Testing of Software and Systems. New York, NY, USA: Wiley, 1995.

[14] G. J. Myers, C. Sandler, and T. Badgett, The Art of Software Testing, 3rd ed. Hoboken, NJ, USA: Wiley, 2011.

[15] P. Ammann and J. Offutt, Introduction to Software Testing, 2nd ed. Cambridge, UK: Cambridge University Press, 2016.

[16] National Institute of Standards and Technology, Digital Identity Guidelines: Authentication and Lifecycle Management, NIST SP 800-63B. Gaithersburg, MD, USA: NIST, 2020.

[17] OWASP Foundation, “OWASP Application Security Verification Standard 4.0.3,” 2021. [Online]. Available: https://owasp.org/www-project-application-security-verification-standard/.

[18] International Organization for Standardization, Information Security, Cybersecurity and Privacy Protection-Information Security Management Systems-Requirements, ISO/IEC 27001:2022. Geneva, Switzerland: ISO, 2022.

[19] R. Aritonang, L. B. Marbun, R. A. Simatupang, and D. M. Rangkuty, “Studi kajian pertumbuhan penduduk di Kabupaten Deli Serdang,” vol. 1, no. 4, 2023.

[20] H. Nasution and A. Abdul, “Analisis performa web server Apache dan Go pada protokol HTTP,” vol. 2, no. 2, 2024, doi: 10.26418/juara.v2i2.81914.

[21] A. G. Gani, P. F. Dewi, and A. Sugiharto, “Sistem informasi point of sale berbasis web,” 2023.

[22] J. H. P. Sitorus and M. Sakban, “Perancangan sistem informasi penjualan berbasis web pada Toko Mandiri 88 Pematangsiantar,” J. Bisantara Inform., vol. 5, no. 2, pp. 1-13, 2021.

[23] M. Fikri, B. M. Husain, I. P. Ndruru, F. Ndruru, and F. Laiya, “Pengembangan sistem informasi berbasis web,” Jurnal Riset Teknik Komputer, vol. 2, no. 1, pp. 1-9, 2025.

[24] A. Z. Surya, A. Fauzi, and A. Prastomo, “Perancangan sistem informasi berbasis web,” Jurnal Riset Teknik Komputer, vol. 1, no. 1, pp. 27-37, 2024.

[25] P. Sepatu, D. A. N. Tas, and K. Padang, “Implementasi website promosi dan penjualan,”