We-Care-Hospital-Administration is a Hospital Database Management System (DBMS) designed to streamline and optimize the administrative functions within a healthcare environment. It aims to simplify the management of critical hospital operations such as patient data, billing, room allocations, prescriptions, and staff management through an easy-to-use graphical user interface (GUI). The system integrates seamlessly with a MySQL database for data storage and retrieval, ensuring efficient and accurate handling of hospital operations.
The hospital management system provides the following functionalities:
- Secure login mechanism to authenticate various users such as doctors, nurses, administrative staff, and other personnel.
- Role-based access control to ensure appropriate data privacy and security, allowing different levels of access based on user roles.
- Register new patients and store their medical history, treatment details, and personal information.
- Schedule appointments and update patient records.
- Efficient retrieval of patient data as needed.
- Allocate hospital rooms to patients based on availability.
- Track room occupancy and manage patient transfers between rooms as required.
- Manage staff records, including doctors, nurses, and support staff.
- Track staff work schedules, shifts, and departmental assignments.
- Generate and manage patient bills, including room rates, treatment fees, and medicine costs.
- Track payments and generate bill reports for accounting purposes.
- MySQL database integration for storing and retrieving critical information, including patient records, billing data, room allocations, and staff details.
- Secure and efficient database operations to ensure data integrity and consistency.
- Backend: Python
- Frontend: Python (Tkinter for GUI)
- Database: MySQL
- GUI Framework: Tkinter
To install and run the We-Care-Hospital-Administration system, follow these steps:
- Clone the repository.
git clone https://github.com/KrishnenduMR/We-Care-Hospital-Administration.git
cd We-Care-Hospital-Administration/src- Install the required dependencies from the
requirements.txtfile.
pip install -r requirements.txt- Set up the MySQL database by creating a database and configuring the connection details in the
config.pyfile. Run the provided SQL script to create the necessary tables. - Run the application by executing
python login.py.
- Launch the application to access the login screen.
- After logging in, use the various modules (Patient Management, Room Management, Staff Management, Billing, etc.) to manage hospital operations.
This project is licensed under the Apache 2.0 License. See the LICENSE file for details.