During the winter of 2016, 6 students worked on an important project for the Rehabilitation Centre for Children who work with parents of children that have physical and developmental challenges. The students created a database, complete with user interface which provided a live, real-time “picture” of production scheduling for equipment. This application tracked equipment such as wheelchairs and prosthetics through the process of production from when they are entered into the system until they are provided to the client. This process was previously done using cards with signatures passing between clinicians and technicians and needed to be automated. This application also generated reports to show the progress of each job as well as weekly, monthly and annual reports. The students created a system that provided the following functionality:
- Create jobs, create and track devices, list jobs, assign jobs to a specific professional, print jobs, list and edit jobs.
- Create users, employees and clients.
- View statistical reports and export data.
The students gained an in-depth experience using database technologies.