PERANCANGAN BASIS DATA RELASIONAL PADA SISTEM REKAM MEDIS ELEKTRONIK PUSKESMAS XYZ
DOI:
https://doi.org/10.69714/8p70zk05Keywords:
Electronic Medical Record, Database Design, Information System, Public Health CenterAbstract
Article 45 of the Regulation of the Minister of Health Number 24 of 2022 mandates all healthcare facilities in Indonesia to implement Electronic Medical Records (EMR). To comply with this regulation, XYZ Community Health Center (Puskesmas XYZ), whose data recording activities currently still rely on conventional or manual medical records, requires a digital transformation through the design of a structured and integrated database. This study aims to design the EMR database architecture at XYZ Community Health Center using the Entity Relationship Diagram (ERD) approach, which is then transformed into the Conceptual Data Model (CDM) and Physical Data Model (PDM) schemas. The methodology in this study was carried out systematically through a series of procedures, starting from problem identification, needs analysis, system design, design implementation, to drawing conclusions. This study successfully developed a database blueprint containing seven integrated main tables. The application of this data architecture is projected to contribute to accelerating the migration from manual systems to EMR, minimizing the risk of data redundancy, increasing service operational efficiency, ensuring the healthcare facility's compliance with government regulations.
References
[1] Kementerian Kesehatan Republik Indonesia, "Peraturan Menteri Kesehatan Republik Indonesia Nomor 19 Tahun 2024 tentang Penyelenggaraan Pusat Kesehatan Masyarakat," Jakarta, Indonesia, 2024.
[2] Kementerian Kesehatan Republik Indonesia, "Peraturan Menteri Kesehatan Republik Indonesia Nomor 24 Tahun 2022 tentang Rekam Medis," Jakarta, Indonesia, 2022.
[3] Kementerian Kesehatan Republik Indonesia. Strategi Transformasi Digital Kesehatan. Jakarta: Kementerian Kesehatan Republik Indonesia, 2021.
[4] Kementerian Kesehatan Republik Indonesia, "Peraturan Menteri Kesehatan Republik Indonesia Nomor 31 Tahun 2019 tentang Sistem Informasi Puskesmas," Jakarta, Indonesia, 2019.
[5] W.S.Duha, A. N. Hakim, C. N. Suci, and Z. Niqotaini, "Perancangan basis data rumah sakit berbasis web dengan ERD, CDM, dan PDM," TEKNOFILE: Jurnal Sistem Informasi, vol. 3, no. 6, pp. 397–411, 2025.
[6] Z. Niqotaini et al., Rekayasa Perangkat Lunak. Yogyakarta: PT Penamuda Media, 2023.
[7] A.Hadi et al., Analisa Sistem Informasi. Yogyakarta: PT Penamuda Media , 2024.
[8] Z.R. Aqil, M. M. L. Gumelar, I. R. Mukhlis, and D. Hermansyah, "Rancang bangun basis data dengan studi kasus penjualan hewan ternak melalui aplikasi dengan ERD dan PDM," Computing Insight: Journal of Computer Science, vol. 6, no. 1, pp. 51–61, 2024.
[9] I.R.Mukhlis and R. Santoso, "Perancangan basis data perpustakaan universitas menggunakan MySQL dengan Physical Data Model dan Entity Relationship Diagram," Journal of Technology and Informatics (JoTI), vol. 4, no. 2, pp. 81–87, 2023.
[10] Z.F. Azzahra and A. D. Anggoro, "Analisis teknik entity-relationship diagram dalam perancangan database sebuah literature review," Intech, vol. 3, no. 2, pp. 70–74, 2022.
[11] Republik Indonesia, Undang-Undang Nomor 27 Tahun 2022 tentang Perlindungan Data Pribadi. Lembaran Negara Republik Indonesia Tahun 2022 Nomor 196.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Jurnal Riset Sistem Informasi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
