Draw an entity relationship diagram.

The Case: CareGiver

You are hired as a business analyst to work for Elderlycare Inc., a not-for-profit organization run by a charity organization based in Melbourne, Australia, established by Divesh Shah and Shizuo (Andrew) Li. As the business analyst of Elderlycare Inc., you will design an innovative mobile-based software solution to connect and manage volunteers for aged care, CareGiver. The goal of CareGiver is to provide a platform to connect nonmedical, in-home caregivers for physically or mentally impaired seniors.

The background

Elderlycare Inc. thoroughly examines volunteer applicants and accepts government- certified home health aides, nursing assistants, licensed vocational nurses and people with recent senior caregiving experience. It also checks driving and criminal records. Before starting work, each service-provider (volunteer applicant) is registered with the Department of Social Services. Senior citizens, or responsible family members, search for volunteers much in the way someone might select from a list of qualified and fully vetted Taskers for a job. Usually, Elderlycare first conduct a face-to-face assessment with the senior citizen who require aged care (senior citizen, or responsible family member), where the company determines the needs, preferences and other considerations of the person in need. Senior citizen users (care receivers) first undergo an initial assessment to determine the types of services they will likely to use. This is used to tailor search results for each senior citizen when looking for volunteers. Assume that senior citizens are able to create their own profiles and family members can be added to their profiles to view their health and well-being.

The mobile app

The mobile app helps to manage the volunteers and acts as a repository for storing the details of the volunteers, activities they carry, senior citizen details and it also acts as a platform that shares information of the seniors with their family members. Once the senior member is registered, the senior or family member can log in at any time to order a volunteer matching their profile to come over and help them make lunch, bathe and dress, take their medications on schedule or go for a walk. The volunteers who are registered on the app receives a notification as soon as they are allocated a task on the mobile app. Divesh and Andrew has identified some of the important aspects of the mobile application:

User Registration

Divesh and Andrew want profiles for the senior citizens, their family member(s) as well as the volunteers. Each user of the mobile app will need to register. This will allow them to access the platform from various devices, apps, browsers and other online services that the user may use. The profile can be minimal but should have options for senior citizen users to fill out a range of health and demographic information such as age, gender, location, weight, and height and specify some fitness goals. All users can also add a profile picture. The senior citizens should be able to enter what they require the volunteer to do for them (tasks).

Task Entries

The core of the CareGiver app is the idea of a task list. For elderly users (senior citizen), the most common entry added to their diary will be some kind of activity that they need help such as cleaning, bathing, walking and dressing them. The app needs to support a wide range of care giving activities. Each type of activity may have a number of different data items recorded. All will include a date, start time and duration. Some, like walking, will include distance covered and comments on their health. Other entries the care givers may enter will be for various health or fitness measurements such as their weight, and in general a comment on how they are on that day. If the volunteer is cooking a meal for the elders, they can also add entries for meals that they eat this would include the date and the type of meal (breakfast, lunch, etc.).

Finally, care givers can also add text-based diary entries and attach photos or videos of the elder that they look after. This maybe a comment on how theyre doing, or some other piece of information theyd like to share with their family. Divesh and Andrew want these entries to be like posts on other social media sites like Facebook. Family members should be able to comment on their elders entries. Using a web browser or the mobile app that will be developed, family members or the elder can manually add an entry to their diary. They should also be able to edit or delete any entries theyve made. This is similar to TaskRabbit where you can enter tasks. Details of TaskRabbit can be found in https://www.taskrabbit.com/.

Social Interaction

Sharing the information with the elders families

As with other social media platforms, care giver users should be able to share the information with their families. The family members will see their elders diary entries in their feed, allowing them to comment on those entries.