RISTEC : Research in Information Systems and Technology
Vol. 7 No. 1 (2026): RISTEC: Research in Information Systems and Technology

Integrated Database Design for the Management Information System of PKBM Nurul Hidayah Assalafiyah

Elin Rosliani (Institut Pendidikan Indonesia Garut)
Moch Wildan (Institut Pendidikan Indonesia Garut)



Article Info

Publish Date
30 Jul 2026

Abstract

Administrative and academic records in non-formal education institutions must be linked reliably across student, tutor, class, schedule, attendance, and assessment activities. This study develops a relational database design for the management information system of PKBM Nurul Hidayah Assalafiyah using the Database Lifecycle approach. The analysis is based on the institutional-process descriptions and design materials available in the manuscript; detailed field notes, interview transcripts, participant counts, and signed requirement validation were not available for independent verification. The proposed model identifies core entities, key relationships, primary and foreign keys, and integrity constraints, and illustrates normalization and MySQL DDL for subsequent implementation. The supplied manuscript includes ERD and database-structure figures, but it does not provide reproducible execution logs or systematic technical test results. Therefore, the contribution is presented as a proposed, traceable database design rather than a validated production implementation. Future work should validate the requirements with PKBM stakeholders and test referential integrity, duplicate prevention, retrieval, and reporting in a deployed database

Copyrights © 2026






Journal Info

Abbrev

ristec

Publisher

Subject

Computer Science & IT

Description

Research in Information Systems and Technology aims to provide scientific literatures specifically on studies of applied research in Information Systems, Information Technology nd public review of the development of theory, method and applied sciences related to the subject. The journal not only ...