Journal of Engineering and Science Application
Vol. 3 No. 2 (2026): Mei-Oktober

Design and Development of a PHP-Based Raskin Data Processing System: A Case Study of Kutambaru Village, Munte District, Karo Regency

Jonatan Sitorus (Universitas Efarina)
Farida Gultom (Universitas Efarina)
Sastra Wandi Nduru (Universitas Efarina)
M. Syaifuddin (Universitas Budi Darma)



Article Info

Publish Date
08 Sep 2026

Abstract

Raskin and social assistance data processing in Kutambaru Village, Munte District, Karo Regency, had relied on manual records that were vulnerable to human error, inconsistent entries, fragmented information, and slow report retrieval. This study aimed to design, implement, and functionally validate an information system developed in PHP that integrates population, household condition, demographic, and assistance data within an administrative environment. The system was developed using the waterfall model through requirements analysis, system design, implementation, testing, deployment preparation, and maintenance planning. Requirements were obtained through observation, document examination, and discussion with a prospective village office user, then translated into flowcharts, data flow and context diagrams, relational database structures, and interface modules. The resulting application provides administrator authentication; population, housing, and hamlet data entry; public program information and beneficiary searches; demographic summaries; an administrative dashboard; population and assistance classification; and printable reports. Functional validation was conducted directly with one prospective end user from the Kutambaru Village Office. Within this limited validation scope, the user confirmed that the documented functions operated in accordance with operational needs. The findings indicate that the application can centralize dispersed records, support more consistent data retrieval, and improve the organization of assistance administration. Nevertheless, the study does not establish targeting accuracy, usability across users, security robustness, or long term administrative impact. Future development should therefore formalize eligibility criteria, implement access controls and audit trails, expand structured testing scenarios, and evaluate processing time, data quality, user satisfaction, and beneficiary targeting outcomes after deployment.

Copyrights © 2026






Journal Info

Abbrev

jesa

Publisher

Subject

Aerospace Engineering Automotive Engineering Chemical Engineering, Chemistry & Bioengineering Civil Engineering, Building, Construction & Architecture Computer Science & IT

Description

Journal of Engineering and Science Application (JESA) is published by the Institute Of Advanced Knowledge and Science in helping academics, researchers, and practitioners to disseminate their research results. JESA is a blind peer-reviewed journal dedicated to publishing quality research results in ...