Moch Wildan
Institut Pendidikan Indonesia Garut

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

Integrated Database Design for the Management Information System of PKBM Nurul Hidayah Assalafiyah Elin Rosliani; Moch Wildan
RISTEC: Research in Information Systems and Technology Vol. 7 No. 1 (2026): RISTEC: Research in Information Systems and Technology
Publisher : Institut Pendidikan Indonesia Garut

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31980/kt76d230

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