International Research Journal of Engineering and Technology (IRJET)
e-ISSN: 2395-0056
Volume: 12 Issue: 09 | Sep 2025
p-ISSN: 2395-0072
www.irjet.net
Design and Development of a Desktop-Based Hospital Information System using Python and MySQL Shoaib Hurrira1, Dr. Joshi Manisha S2 1Post Graduate Student, Department of Medical Electronics Engineering, BMS College of Engineering, Bengaluru,
India
2Professor, Department of Medical Electronics Engineering, BMS College of Engineering, Bengaluru, India
---------------------------------------------------------------------***--------------------------------------------------------------------visualization tools complicates hospital administrators’ Abstract - Effective management of hospital data and
ability to derive actionable insights regarding operational performance.
workflows is essential for enhancing patient care, administrative efficiency, and the overall quality of healthcare. Conventional hospital management systems frequently face challenges due to manual record-keeping, data duplication, and inefficiencies in scheduling and billing methods. This project introduces a desktop-based Hospital Information System (HIS) aimed at optimizing these processes through a single, cohesive platform. The system includes modules for patient registration, appointment scheduling, billing, and staff management, accompanied by integrated graphical analytics to monitor hospital performance. By utilizing Python (Tkinter) for the user interface and MySQL for the backend database, this application facilitates secure data storage, real-time CRUD operations, and interactive dashboards. A reporting module creates visual summaries and statistical charts to aid hospital administrators in their decision-making processes. This solution is 2lightweight, scalable, and ideal for small to mid-sized healthcare facilities. The goal is to close the gap between traditional hospital operations and contemporary digital healthcare by providing a cost-effective, user-friendly, and efficient management system.
To tackle these issues, this paper introduces a secure and scalable desktop-based Hospital Information System (HIS) built with Python (Tkinter) and MySQL. This system integrates key hospital processes—such as patient registration, staff management, appointment scheduling, room assignment, and billing—into a single platform. In addition, it features a graphical results module using Matplotlib to produce real-time analytics, allowing administrators to effectively track hospital trends and performance metrics. The proposed HIS facilitates structured data storage, realtime CRUD operations, and features for generating printable reports. The modules are designed to be lightweight and modular, providing enhanced functionality such as conflict resolution for appointments, dynamic search filters, and data backup for compliance audits. The application also incorporates UI design best practices and data validation, ensuring accessibility for hospital personnel with minimal training.
Key Words: Hospital Information System, Python, MySQL, Appointment Scheduling, Billing, Graphical Dashboard, Healthcare IT, Data Visualization.
The key contributions of this work include:
1. INTRODUCTION Effective hospital management is crucial for providing prompt and high-quality healthcare services. However, conventional hospital systems frequently experience disjointed workflows, manual record maintenance, redundant procedures, and ineffective scheduling. These issues are especially significant in small to mid-sized healthcare establishments, where the lack of unified digital platforms results in delays, data discrepancies, and suboptimal resource use.
Core hospital operations, including patient registration, appointment scheduling, billing, and staff coordination, are essential for daily functioning. Manual methods of handling these tasks often lead to overlapping appointments, delayed treatments, and inaccuracies in financial records. Furthermore, the absence of centralized data access and
© 2025, IRJET
|
Impact Factor value: 8.315
|
Designing and implementing a modular, desktop-based HIS that unifies essential functions like patient registration, appointment scheduling, billing, staff, department, and room management. Ensuring secure and relational data management using MySQL, with established schemas, validation rules, and consistency checks. Introducing a visual analytic feature to monitor patient inflow, billing details, and departmental statistics utilizing Matplotlib. Offering a cost-effective and scalable solution for small and medium-sized hospitals without enterprise-level infrastructure. Laying the foundation for future improvements, including RESTful API integration, cloud deployment, mobile application compatibility, and AI-powered healthcare analytics.
ISO 9001:2008 Certified Journal
|
Page 160