Authors : Val John Diego; John Cristian Bacol; Joshua Van Ratunil; Geovanni Sat-ao; Dexter Kim Santo; Marlo Romero

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

Google Scholar : https://tinyurl.com/235ehpay

Scribd : https://tinyurl.com/2kzrwxwt

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

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 study aims to address the inefficiencies in FurCare Veterinary Clinic’s manual record-keeping and disconnected systems, which leds to scheduling conflicts, poor inventory tracking, and inaccessible pet records. The clinic's reliance on manual record-keeping and disconnected software led to persistent scheduling conflicts, ineffective inventory tracking, and difficult access to pet medical histories. The primary objective was to design and implement a centralized, web-based solution to automate core tasks and unify data management across two branches. Developed iteratively using the Agile methodology, the system leverages a robust tech stack including PHP, MySQL, and Bootstrap for the frontend, integrated with the PhilSMS API for timely communication. Designed for administrators, veterinarians, staff, and pet owners, its essential functionalities encompass online appointment scheduling, automated SMS reminders, digital medical records, and real-time inventory tracking. These integrated features successfully streamline workflows, enhance data accuracy, and significantly improve the overall quality of service delivery. Evaluation showed major improvements in speed, accuracy, and user satisfaction, achieving a high 86.5 usability score. The system proved very effective based on testing and user feedback. In conclusion, it successfully modernized the clinic's operations, with potential for a mobile app, expansion of inventory management, improvement or addition of features in the future.

Keywords : Appointment Scheduling, Centralized, Inventory Tracking, Manual Record-Keeping, Scheduling Conflicts, SMS Reminders, Veterinary Clinic And Web-Based.

References :

1. Blancaflor, E., Dela Cruz, J. K., Dalanon, C. A., & Lumbang, R. A. (2023). PawHub: A web-based telehealth application for companion-animal veterinarians. Laguna State Polytechnic University. https://doi.org/10.1145/3608251.3608285
2. Blancaflor, E., Guevarra, A., Agbayani, M. A., & Mariano, J. (2024). VETGO: A mobile application designed for pet veterinary services. In Proceedings of the 7th International Conference on Computers in Management and Business (ICCMB 2024). https://doi.org/10.1145/3647782.3647806
3. Chua, S., Alis, J., & Oria, M. J. (2024). WEB-Based veterinary clinic with email and SMS notification. In Proceedings of the 9th International Conference on Business and Industrial Research (ICBIR 2024). https://doi.org/10.1109/ICBIR61386.2024.10875747
4. Llaneta, J. C., Guelas, C. J., Mercado, J., Sasis, R., & Labanan, R. (2022). TerraVet: A mobile and web application framework for pet owners and veterinary clinics. In Proceedings of the 4th International Conference on Intelligent Science and Technology (ICIST 2022). https://doi.org/10.1145/3568923.3568927
5. Pasarič, F., & Pušnik, M. (2022). Comparison of project management tools. CEUR Workshop Proceedings, 3237, 1–12. https://ceur-ws.org/Vol-3237/paper-pas.pdf
6. Ahmad, M. S., & Salamat, M. A. (2023). Pet Health Management System for Gebuu Veterinary Clinic. Applied Information Technology And Computer Science, 4(2), 1016-1033. https://penerbit.uthm.edu.my/periodicals/index.php/aitcs/article/view/11996
7. Balasooriya B.M.D.D, Rathnayaka R.M.S.Y, Dilshani M.G.S.U, Perera K.S.C, D. I. De Silva, & H.M.P.K. Samarasekara. (2022). Dogs Health Care Management System. International Journal of Engineering and Management Research, 12(5), 99–103. https://doi.org/10.31033/ijemr.12.5.12
8. Diez, E., Renner, A., & Ózsvári, L. (2023). Digitalization in veterinary medicine: The perception and acceptance of digitalized animal healthcare by owners in Germany. Acta Veterinaria Eurasia, 49(2), 69-74. Retrieved from https://tinyurl.com/25b4msxy
9. Carvalho, G., Mykolyshyn, S., Cabral, B., Bernardino, J., & Pereira, V. (2022). Comparative analysis of data modeling design tools. IEEE Access, 10, 3351–3365. https://doi.org/10.1109/ACCESS.2021.3139071
10. Jaffar, N. B., & Mohd Zin, N. A. (2021). The development of veterinary clinic management system using structured approach. Universiti Tun Hussein Onn Malaysia. https://publisher.uthm.edu.my/periodicals/index.php/aitcs/article/view/2339
11. Johnson, D. C., George, P. R., Jiji, R. S., Rajeev, T. S., Unni, N. M., & Gleeja, V. L. (2021). Development and assessment of the quality of a mobile application on canine health care and management for veterinarians. The Pharma Innovation Journal, 10(2), 438-441. Retrieved from https://tinyurl.com/228r586z
12. Mukhlis, I. R., Hermansyah, D., & Hariyanti, T. A. (2023). Model view controller method for animal care (Petcare) information system at Niz Petcare Lawang. Journal of Electrical Engineering and Computer Sciences, 8(2), 103–122. https://doi.org/10.54732/jeecs.v8i2.2
13. Rosmani, N. N., & Mokhtar, M. M. (2023). Veterinary Online Appointment Booking System (VOAS). International Islamic University Malaysia. https://ir.uitm.edu.my/id/eprint/82837/

14. Sotnik, S., Manakov, V., & Lyashenko, V. (2023). Overview: PHP and MySQL features for creating modern web projects. International Journal of Academic Information Systems Research (IJAISR), 7(1), 11–17. https://openarchive.nure.ua/entities/publication/d32fc946-4bb2-4ad9-bce3-aac5f376b4eb