Web-Based Inventory Information System for Asset and Consumable Management at Ratumbuysang Mental Hospital
DOI:
https://doi.org/10.69916/jkbti.v5i3.613Keywords:
Inventory Information System, Web Application, React.js, Waterfall, QR CodeAbstract
This study aimed to design and develop a web-based Inventory Information System for Ratumbuysang Mental Hospital to address inventory management that was previously performed manually. Manual recording made inventory searching, asset tracking, and report preparation less efficient and increased
the risk of recording errors. The system was developed using the Waterfall method through requirements analysis, system design, implementation, testing, and maintenance. The application uses React.js for the frontend, Node.js and Express.js for the backend, PostgreSQL for data management,
and Prisma ORM as the database interface. The implemented functions include item master-data management, incoming assets, outgoing assets, consumable items, user management, report generation, and QR Code-based asset identification. Black Box Testing was conducted using 27 functional scenarios and showed that all tested functions operated according to the expected
results. User Acceptance Testing (UAT) involved 24 statements using a five-point Likert scale. The overall mean score was 4.68, equivalent to 93.50%, and was categorized as Very Good in the original evaluation. These findings indicate that the developed system was accepted by users and can support structured inventory management at Ratumbuysang Mental Hospital.
Downloads
References
A. Banks and E. Porcello, Learning React: Modern Patterns for Developing React Apps, 2nd ed. Sebastopol, CA, USA: O’Reilly Media, 2020.
A. Dennis, B. H. Wixom, and D. Tegarden, Systems Analysis and Design: An Object-Oriented Approach
with UML, 6th ed. Hoboken, NJ, USA: John Wiley & Sons, 2020.
R. S. Pressman, Software Engineering: A Practitioner’s Approach, 8th ed. New York, NY, USA: McGraw-
Hill Education, 2020.
A. Fauzi, “Implementasi Sistem Informasi Inventory Berbasis Web (Studi Kasus: CV. Sinar Abadi Cemerlang),” J. Sist. dan Teknol. Inf., vol. 5, no. 1, pp. 29–37, 2022.
S. R. Octavianus, “Rancang Bangun Sistem Informasi Inventory Barang Berbasis Web (Studi Kasus: Toko Dina Beauty Care),” J. Teknol. Inf. dan Komp., vol. 6, no. 2, pp. 45–53, 2021.
R. Yuliani, “Sistem Informasi Inventaris Barang di Puskesmas Kemlagi Berbasis Web,” J. Teknol. Inf. dan Komp., vol. 8, no. 2, pp. 45–52, 2022.
A. Siregar, “Penerapan Metode Waterfall pada Pengembangan Sistem Informasi Berbasis Web di Lingkungan Kesehatan,” J. Inform. dan Teknol., vol. 10, no. 2, pp. 74–82, 2023.
R. Murdani, “Aplikasi berbasis web untuk mendukung kinerja organisasi,” J. Teknol. dan Sist. Inf., vol. 9, no. 1, pp. 66–74, 2023.
T. Pramudia, “Desain sistem informasi administrasi rawat inap pasien BPJS IGD di Rumah Sakit Muhammadiyah Bandung dengan metode waterfall,” JMeRS J. Med. Rec. Stud., vol. 2, no. 3, pp. 88–95, 2024.
A. Nugroho, Pemrograman Web Dinamis dengan JavaScript dan Node.js. Jakarta, Indonesia: Elex Media Komputindo, 2022.
The PostgreSQL Global Development Group, “PostgreSQL Documentation,” 2025.
International Organization for Standardization, “Information Technology—Automatic Identification and Data Capture Techniques—QR Code Bar Code Symbology Specification,” ISO/IEC 18004:2015, 2015.
M. Chandra, R. P. Pratama, F. A. Pradana, and A. Bonita, “Chatbot Interaksi Rumah Sakit Menggunakan FFNN,” Indones. J. Data Sci., vol. 3, no. 1, pp. 36–44, 2022, doi: 10.56705/ijodas.v3i1.36.
M. R. Nugroho and I. E. Hendrawan, “Penerapan Algoritma K-Means Untuk Klasterisasi Data Obat Pada Rumah Sakit,” J. Comput. Sci., vol. 16, no. 2, pp. 125–133, 2022.
A. Rahma and A. I. Suryani, “Analisis Penggantian Password User Id Dalam Sistem Rekam Medis Elektronik Guna Menjaga Keamanan Data Rekam Medis Di Rumah Sakit Hermina Arcamanik,” Media Bina Ilm., vol. 18, no. 12, pp. 3139–3146, 2024.
M. Dwi Payana, Z. Musliyana, Z. Ardhian, M. B. Wibawa, D. Ria, and Y. Tb, “Sistem Pendajadwalan
Dokter dan Fasilitas Poli pada Rumah Sakit Sultan Iskandar Muda Nagan Raya Berbasis Android Menggunakan Flutter,” J. Inform. Comput. Sci., vol. 9, no. 1, pp. 27–33, 2023.
Z. Mutaqin, B. Imran, and S. Rosida, “Sistem Informasi Penjualan Online (E-Commerce) Berbasis
Web Pada Toko Matahari Praya,” J. Comput. Technol., vol. 1, no. 2, pp. 29–36, 2023, doi:
69916/comtechno.v1i2.46.
E. Febriani, B. Imran, and R. Muslim, “Sistem Informasi E-Commerce Penjualan Kerajinan Rotan Berbasis Website Pada Desa Loang Maka Kecamatan Janapria,” J. Comput. Technol., vol. 1, no. 1, pp. 32–40, 2023.
M. Raihan and Tommy, “Majority-Class Collapse in E-Commerce Emotion Mining: A Diagnostic Evaluation of LSTM Under Severe Class Imbalance and Noisy Text,” J. Comput. Technol., vol. 4, no. 1, pp. 1–13, 2026.
T. Ramadhani, S. Nabilah, A. Abimayu, and T. Loi, “Pengembangan sistem rekomendasi produk ecommerce menggunakan algoritma collaborative filtering,” RIGGS J. Artif. Intell. Digit. Bus., vol. 4, no.
, pp. 4848–4854, 2025.
Downloads
Published
Scite Metrics
Altmetric
How to Cite
Issue
Section
License
Copyright (c) 2026 Faith Nathaniel Alexander, Chriestie E. J. C. Montolalu, Wisard Kalengkongan, Christian Alderij Soewoeh, Mahardika Inra Takaendengan, Stephano C.W. Ngangi
This work is licensed under a Creative Commons Attribution 4.0 International License.
menuterbaru
