Authors : Krystal Jane N. Bongabong; Bency S. Cabugsa; Junel Micabalo; Maria Niña Angel C. Pinohon; Cheryll S. Santisas; Mary Alchery N. Saplot; Jefrey Del Rosario

Volume/Issue : Volume 10 - 2025, Issue 12 - December

---

Google Scholar : https://tinyurl.com/y4h562xu

Scribd : https://tinyurl.com/539xkvt2

DOI : https://doi.org/10.38124/ijisrt/25dec1463

Note : A published paper may take 4-5 working days from the publication date to appear in PlumX Metrics, Semantic Scholar, and ResearchGate.

---

Abstract : This capstone project developed a web-based Appointment and Patient Record Management System for Kamatage Trading Hearing and Health Solution, a multi-branch audiological center. Using the Waterfall SDLC model, the system was built with Laravel (PHP), MySQL, and HTML/CSS/JavaScript, supported by tools like Gmail SMTP, DOMPDF, and Chart.js for notifications, reporting, and visualization. It provided role-based access for patients, staff, and administrators, offering centralized records, appointment scheduling, billing, reporting, and secure communication. Testing and user feedback confirmed improved accuracy, reduced waiting times, elimination of double bookings, and overall efficiency in clinic workflows.

Keywords : Appointment, Patient Record, MySQL Waterfall SDLC, Web-Based, Laravel PHP Framework.

References :

1. \Abdulkadir, A., Aiyedun, T. A., Shoretire, K., Danladi, A., & Others. (2024). Paper-based medical records: The challenges and lessons learned from studying obstetrics and gynaecological post-operation records in a Nigerian hospital. TAF Preventive Medicine Bulletin, 9(5), 427–432.
2. Akingbade, O. L., & Onwuasoanya, N. C. (2022). A web-based online doctor’s appointment and medical database management system. IRE Journals, 6(5), 18–22
3. Amusa, A., Akinnukawe, O., Balogun, I. O., Iribhogbe, C. K., Mensah, Y., Bamidele, O., & Adelowo, J. (2024). Development of a web-based medical appointment booking system. International Journal of Scientific Research and Engineering Development, 7(2), 1112–1118
4. Bagheri, F., Behnam, F., Galavi, Z., & Ahmadian, L. (2022). The use of various appointment systems among patients visiting academic outpatient centers in Kerman and the evaluation of patients’ perspective and satisfaction. BMC Health Services Research, 22(1), Article 1344
5. Gumabay, M. V., & Corpuz, C. B. (2021). Web-based medical information with inventory system of LGU Jones Health Services Unit Jones, Isabela. International Journal of Science and Advanced Information Technology, 10(2), 8–15.
6. Karunathilake, G. K. B. V., Wijesinghe, G. A. T. T., Samarakoon, H. M. W. T. C. B., Ovitigala, A. U., De Silva, D. I., & Samarasekara, H. M. P. P. K. H. (2022). An integrated management system for a medical center. International Journal of Engineering and Management Research, 12(5), 180–188
7. Mani, V., Manickam, P., Alotaibi, Y., Alghamdi, S., & Khalaf, O. I. (2021). Hyperledger Healthchain: Patient-centric IPFS-based storage of health records. Electronics, 10(23), 3003.
8. Olipas, C. N. P., Viloria, J. P., Mateo, S. M., Maria, S. A. P. S., Bisnar, E. A., & Vallecera, M. L. M. (2022). MediCord: A web-based health record management system. Journal of Healthcare Treatment Development, 25, 35–5.
9. Paré, G., Raymond, L., Castonguay, A., Grenier Ouimet, A., & Trudel, M.-C. (2021). Assimilation of medical appointment scheduling systems and their impact on the accessibility of primary care: Mixed methods study. JMIR Medical Informatics, 9(11), e30485
10. Pavliv, I., & Pasichnyk, V. (2023). Data security requirements of the medical information system. ResearchGate.
11. Precious, M. A. (2021). Design and implementation of hospital appointment management system. Caleb University
12. Reguyal, J. M. T., Agno, A. M. S., Martinez, M. C., Castro, J. T., Cariazo, B. V. C., Olipas, C. N. P., & Alegado, R. T. (2023). Ob-Gyn clinic online scheduling system. Formosa Journal of Computer and Information Science, 2(1), 25–36.
13. Yarima, K. I., Lawan, A. A., Umar, I. A., Uba, H. U., & Haruna, Y. (2024). Development and implementation of a new patient appointment scheduling system at ADUSTECH Wudil: An evaluation of user satisfaction and system impact. Journal of Computational Innovation and Analytics, 3(2), 27–56.
14. Simeon, I. F., & Nlerum, P. (2024). Design and development of a medical appointment and evaluation management model. SSRN
15. Sutton, F. N. (2024). An exploration of mHealth applications usage among older adults: A mixed methods study (Doctoral dissertation, University of Central Florida).