Design of a Drug Inventory Information System at Janji Primary Health Center Using a MySQL Database

PeZaitun Ritonga, Masrizal Masrizal, Rahma Muti’ah

Abstract


This research is backgrounded by observation data at the Labuhanbatu appointment health center and uses the MYSQL database system to help support research results. MySQL is also known as a SQL-based open-source relational database management system (RDBMS) that works with a client-server model which functions for data warehousing (data warehouse), which is data collection from various sources, for e-commerce, as well as logging applications. Information systems are an important factor in Indonesia today, supporting operational activities and institutions for companies. An information system is an internal organizational system that meets the needs of day-to-day event management, supports operations, represents the specific management of the organization, and supports strategic operations with the necessary reports. The system design includes drug inventory, Primary Health Center Standards, and Drug Services. The research methods used are a combination of survey research, problem identification, data collection, data analysis, system design, and implementation. This research also aims to make more agencies know how to work quickly and easily using MYSQL databases, researchers hope that in this digital era people will know more and understand more about information systems and their uses to help in work.The result of this research is that the puskesmas is willing to consider the problems that arise from the current system, which is recommended to implement and utilize computerized systems that offer a more effective and efficient data search process. The proposed system is a modification of the ongoing system, namely the Design of the Drug Stock Information System at the Promise Health Center. This system design uses PHP, CSS, Bootstrap Designer, and MySQL. Therefore, the design results obtained include a program interface consisting of Files, Transactions, Reports, and Final Programs (Exit).


Keywords


MySQL; database; drug inventory; information system; design

Full Text:

PDF

References


A. R. Damanik, W. Saputra, D. Hartama, I. Gunawan, and S. Darma. (2022). “PELATIHAN IMPLEMENTASI PROGRAMMING WEB MENGGUNAKAN BOOTSTRAP PADA SMK TELADAN PEMATANG,” vol. 3, no. 2, pp. 371–375.

D. T. Martmusic, A. K. Rahman, S. Mardiyati, and Y. Nugraha, “Perancangan Sistem Informasi Penjualan barang Berupa Alat Music,” pp. 86–95.

J. Asmara. (2019). “Rancang Bangun Sistem Informasi Desa Berbasis Website ( Studi Kasus Desa Netpala ),” no. 2.

K. Wau. (2022). “Pengembangan Sistem Informasi Persediaan Gudang Berbasis Website Dengan Metode Waterfall,” J. Tek. Komputer, Agroteknologi Dan Sains, vol. 1, no. 1, pp. 10–23, doi: 10.56248/marostek.v1i1.8.

M. Musyarofah, H. Fajarini, R. F. Balfas, and E. Dence. (2021). “Pengaruh Implementasi Pelayanan Informasi Obat Terhadap Tingkat Kepuasan Pasien Di Apotek,” J. Ilm. JOPHUS J. Pharm. UMUS, vol. 2, no. 02, pp. 1–9, doi: 10.46772/jophus.v2i02.422.

M. P. Baybo, W. A. Lolo, and M. Jayanti, (2022). “Analisis Pengendalian Persediaan Obat Di Puskesmas Teling Atas,” J. Farm. Medica/Pharmacy Med. J., vol. 5, no. 1, p. 7, doi: 10.35799/pmj.v5i1.41434.

M. Sari. (2019). “Aplikasi Data Pasien Dan Penentuan Gizi Ibu Hamil Pada Puskesmas Sungai Tabuk,” Technol. J. Ilm., vol. 10, no. 3, p. 172, doi: 10.31602/tji.v10i3.2232.

P. Yunita and D. M. Sari. (2020). “Sistem Informasi Persediaan Obat Pada Puskesmas Sungai Sembilan Berbasis Web,” I N F O R M a T I K a, vol. 12, no. 1, p. 14, doi: 10.36723/juri.v12i1.207.

R. Hermiati, A. Asnawati, and I. Kanedi. (2021). “Pembuatan E-Commerce Pada Raja Komputer Menggunakan Bahasa Pemrograman Php Dan Database Mysql,” J. Media Infotama, vol. 17, no. 1, pp. 54–66, doi: 10.37676/jmi.v17i1.1317.

R. Setiyanto, N. Nurmaesah, and N. S. A. Rahayu. (2019). “Perancangan Sistem Informasi Persediaan Barang Studi Kasus di Vahncollections,” J. Sisfotek Glob., vol. 9, no. 1, pp. 137–142, doi: 10.38101/sisfotek.v9i1.267.

R. Setiyanto, N. Nurmaesah, N. Sri, and A. Rahayu. (2019). “288089183 Jurnal Perancangan Menurut Setiyanto,” vol. 9, no. 1, pp. 137–142.

S. Ernawati. (2020). “Analisa Pieces Untuk Rancang Bangun Sistem Informasi Monitoring Persediaan Barang Berbasis Web Pada Koperasi Sartika Bogor,” EVOLUSI J. Sains dan Manaj., vol. 8, no. 1, pp. 18–28, doi: 10.31294/evolusi.v8i1.7386.

S. Suhartini, M. Sadali, and Y. Kuspandi Putra. (2020). “Sistem Informasi Berbasis Web Sma Al- Mukhtariyah Mamben Lauk Berbasis Php Dan Mysql Dengan Framework Codeigniter,” Infotek J. Inform. dan Teknol., vol. 3, no. 1, pp. 79–83, doi: 10.29408/jit.v3i1.1793.

X. Jiping, L. Ruina, and D. Haixia. (2020). “谢计平 1 ,李瑞娜 2 ,丁海霞 3* (1,” vol. 4, no. 3, pp. 2019–2020.

Y. Anggraini, D. Pasha, and A. Setiawan. (2020). “Sistem Informasi Penjualan Sepeda Berbasis Web Menggunakan Framework Codeigniter (Studi Kasus : Orbit Station),” J. Teknol. dan Sist. Inf., vol. 1, no. 2, pp. 64–70, [Online]. Available: http://jim.teknokrat.ac.id/index.php/JTSI




DOI: https://doi.org/10.33258/birci.v6i3.7696

Article Metrics

Abstract view : 0 times
PDF - 3 times

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

 

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.