Our Underlying Goal
The main purpose of our database is to provide Sunshine Acres with a way to obtain information regarding the vast amount of residents within the assisted living home. Specifically, we designed the database around the initially chaotic activities department. For years, the activities department used paper files in an unorganized manner to keep track of the various activities that were made available to the residents. Under this method, it was difficult to determine what residents attended certain activities, how many attended, and how each activity was received . As a result, it was hard to accurately keep track of the resources being allocated towards each activity.
With our new database, we have established several forms and useful reports that help keep track of what actually goes on within each activity. Our Participation report breaks down the level of participation for each activity. It shows what activities we should continue to plan, and what activities we should consider changing. Thus, the resources that Sunshine Acres are better allocated as to what is actually needed because of this database. As a result, the residents benefit from this database, as they are kept better track of, and the users benefit because it helps better manage decision making.
With our new database, we have established several forms and useful reports that help keep track of what actually goes on within each activity. Our Participation report breaks down the level of participation for each activity. It shows what activities we should continue to plan, and what activities we should consider changing. Thus, the resources that Sunshine Acres are better allocated as to what is actually needed because of this database. As a result, the residents benefit from this database, as they are kept better track of, and the users benefit because it helps better manage decision making.