Purpose
The main purpose of this project is to display a daily schedule for providing care to patients.
Originally conceived as a way to practice working with a relational database, this project has evolved into a centralized solution to reduce confusion among staff regarding constantly changing patient schedules.
By offering a centralized and up-to-date version of the schedule that can be easily updated on-the-go, this project aims to simplify the task of managing patient care, especially for new staff members.
In addition, the monthly scheduling sheet provides an at-a-glance overview for staff and enables nurses to make quick adjustments as needed.
Functionality
This project seamlessly retrieves and displays data from a MySQL database in a well-organized and user-friendly format.
Administrative users have the ability to efficiently manage and manipulate schedules.
The daily schedule presents patients' hourly ADLs (Activities of Daily Living), offering the flexibility to highlight specific houses and shifts for comprehensive viewing.
The monthly schedule provides a convenient calendar view that highlights different houses and shift times, facilitating efficient staff scheduling across multiple facilities.
Challenge
During the project, the main challenge was retrieving data from the database, which was not functioning correctly. It was discovered that resetting the MySQL server through Windows Services was necessary.