Online Caregivers Platform

Platforms have become popular for finding trustful caregivers. Caregivers on several categories (e.g. babysitters, for elderly care) register to the platform, and families who seek a caregiver may search among the candidates and make an appointment via the platform. In this project, you are required to implement such a platform with the following features:

1. Caregivers register to the platform with the following information:

a. Name
b. Surname
c. Type of caregiving (one of the categories: babysitter, caregiver for elderly, playmate for
children)
d. Gender
e. Photo
f. Mail address
g. Phone number
h. City
i. Price requested per hour
j. Biography and personal information: A short description of the caregiver such as education information, working experience
k. Password

2. Family members who seek a caregiver also register to the system with the following information:

a. Name
b. Surname
c. Mail address
d. Phone number
e. Password
f. City
g. Address
h. Information about the person
i. House rules: Description about the house rules that the caregiver should follow (e.g. the
caregiver should pay attention to hygiene…)

3. Family members can search caregivers based on the caregiving type and city.

4. Family members can also post a job advertisement about the need of caregiving, hence, caregivers also search among the announcements and apply them.

a. Since posting an advertisement is a more detailed process, family members explicitly state the criteria that should be met by the caregiver. For example, age of the person who need caregiving, time interval (between 09:00-12:00, 12:00-15:00 etc.) and frequency (weekly, daily, only weekends etc.) for the caregiving service should be stated in the announcement.

b. Members can see the applicants to the advertisements posted by the member, and view the profiles of the applicants.

5. Members can view profiles of the potential caregivers that satisfy their conditions. On the profile, they can send a message to the caregiver, or they can allow the caregiver to contact with them.

6. Members can make an appointment with the caregivers on their profiles.

a. For making an appointment, members state

i. Date of the appointment
ii. Hour of the appointment
iii. Total number of hours for caregiving service (e.g. 3 hours, 5 hours)

b. If a member creates an appointment with a caregiver, caregiver should confirm or decline the request.

c. If the appointment is confirmed, the contact information is shown to both members and caregivers.

d. Members can see their appointments on their profiles.

DELIVERABLES AND CONSTRAINTS IN THE ASSIGNMENT:

ER/EER Diagram:

• You should provide your project's ER/EER diagram. You are supposed to show entities, weak entities and relations with min-max constraints.
• Schema Design and Functionality of the System: You should provide the schema design (tables, primary and foreign keys). You should present the functionality of your system (forms, screens and reports)

The constraints of the project are as follows:

• You must have insert, delete, and update operations satisfying integrity constraints. You should perform these operations on two tables.
• You should develop 4 complex queries, two with aggregate functions, and two that involves multiple tables to be joined, preferably nested queries.
• Include a derived attribute, date or time information in your database design and perform at least one query comprising these values.
• Provide printed report and/or displayable form capabilities.
• You must implement one dynamic SQL query with programming utilities. (Wait for a parameter to be entered from the screen and produce information accordingly. You can use JDBC). You may prefer to use Hibernate.

You can use an object-relational mapping library such as Hibernate but you should present sufficient evidences for the constraints asked for the queries such as complex queries during the demonstration.

• Error and exception handling should be done and demonstrated at the demo phase.
• A view satisfying certain constraints should be implemented.