CS-243|Database Systems

Project Proposal

Instructor: Dr. Qaiser S Durrani

Date: May 12, 2024

1
Project Title:

Care Connect

Group Members:

Sr No. Name Roll No.

1 Muhammad Asad Ullah (GL) 221400089
2 Jawad Akhtar 221400071
3 Rana Zunair 221400101
4 Muhammad Moaz 221370187

2
Table of Contents:
1. Problem Statement 04
2. Scope
2.1 Do 04
2.2 Don’ts 04
3. Functional Requirements 05

1. Problem Statement:

3
The project aims to design and implement a database system for a platform that connects
individuals seeking assistance with skilled professionals in the domestic and healthcare
services sector. The challenge is to create a reliable and secure system that addresses
concerns related to trust, security, quality assurance, and legal compliance.

2. Scope:
2.1 Do:
1. We’ll allow both customers and workers to sign up and create their profiles to
ensure trust, reliability and legal compliance.
2. The system will also allow both customers and workers to login if they have already
an account.
3. We’ll integrate a third party banking service to process payments made by
customers in a secure way.
4. We’ll implement functionality for customers to browse different service categories
and search for specific services and workers by their name.
5. We’ll also implement a chatting feature that will allow both customers and worker to
negotiate about the amount that the worker will charge.
6. We’ll streamline the process of hiring a worker as much as possible by utilizing
profile of customer.
7. We’ll implement a review system that’ll allow the customer to open customers
profile and then give reviews.
2.2 Don’ts:
1. No Automated Hiring Confirmation: We’ve decided not to include an automated
system that dispatches hiring confirmation emails to customers. We believe in
keeping the hiring process personal and less mechanized.
2. Limited In-app Messaging: While we’re incorporating a chat feature for price
negotiation, we won’t be extending this to a comprehensive in-app messaging
system. This decision is driven by our commitment to privacy and preventing
potential misuse.
3. No Real-time Availability Tracking: We won’t be tracking the real-time availability of
workers. This decision is based on the complexity of real-time updates and respect
for the privacy of our workers.
4. No In-app Training or Certification: We won’t be offering in-app training or
certification for workers. While we value service quality, we believe this is best
handled outside of the app due to the resources required.
5. Basic Search and Filtering: We’re keeping our search and filtering options simple.
Customers can browse and search for services and workers, but we won’t be offering
advanced search options to avoid overwhelming users with choices.
6. No Social Media Integration: We’ve decided not to integrate with social media
platforms. We believe in keeping our platform separate and maintaining the privacy
of our users.

4
 3. Functional Requirements:

3.1 Client can sign up

FR3.1.1: Display Sign-Up Form

 The system shall display a sign-up form when a client chooses to create a new account.
FR3.1.2: Collect Client Information

 The system shall collect necessary information from the client during sign-up, including full
name, email address, password, and phone number.
FR3.1.3: Validate Client Information
 The system shall validate the client’s input data to ensure it meets the specified format
and is not already in use by another account.
FR3.1.4: Create Client Account

 Upon successful validation, the system shall create a new client account and store the
client’s information securely.
FR3.1.7: Enable Client Login

 The system shall allow the client to log in to their account after the sign up.
FR3.1.8: Display Error Message

 If the validation fails, the system shall display an error message explaining the reason for
the failure.
FR3.1.9: Password Security

 The system shall securely hash and store the client’s password.

3.2 Service Provider can create profile

FR3.2.1: The system shall allow the service provider to create a new account by entering their basic
information (first name, last name, email address, phone number, and business name (optional)).

FR3.2.2: The system shall require the service provider to set login credentials (username, password)

FR3.2.3: The system shall allow the service provider to complete their profile by entering a company
description (optional).

FR3.2.4: The system shall allow the service provider to complete their profile by entering a location
(address and service area).

FR3.2.5: The system shall allow the service provider to complete their profile by entering a contact
information (phone, email).

5
FR3.2.6: The system shall offer the service provider the ability to select available days for service
provision.

FR3.2.7: The system shall allow the service provider to define both recurring and one-time
availability schedules.

FR3.2.8: The system shall provide the service provider with the ability to define service-specific rates
(hourly, fixed price, etc.).

FR3.2.9: The system shall offer the service provider the option to create package deals or discounts
for their services.

FR3.2.10: The system shall allow the service provider to specify additional charges, such as travel
fees or materials.

FR3.2.11: The system shall enable the service provider to select the type of services they offer.

FR3.2.12: The system shall allow the service provider to choose specific service categories within
each type.

FR3.2.13: The system shall provide an option for the service provider to upload relevant qualification
documents to support their service offerings.

FR3.2.14: The system shall allow the service provider to write a detailed bio.

FR3.2.15: The system shall allow the service provider to upload a professional profile picture
(optional).

3.3 Client can login in the system

FR3.3.1: System should let the client to login into the system by entering credentials (Username,
Password).

3.4 Service Provider can login in the system

FR3.3.1: System should let the service provider to login into the system by entering credentials
(Username, Password).

3.5 Client can search for service providers

FR3.5.1 - Search Functionality: The system shall provide a search bar where clients can input
keywords related to the services they are looking for.

FR3.5.2 - Service Category Browsing: The system shall categorize service providers based on the
type of service they offer. Clients shall be able to browse these categories.

6
FR3.5.3 - Filtering: The system shall allow clients to filter search results based on various criteria
such as location, availability, expertise, ratings, and pricing.

FR3.5.4 - Sorting: The system shall allow clients to sort search results based on relevance, ratings,
number of reviews, and price.

FR3.5.5 - Provider Profiles: The system shall provide detailed profiles for each service provider that
clients can view. This profile shall include information about the provider’s experience, certifications,
reviews, and pricing.

FR3.5.6 - Location-Based Search: The system shall allow clients to search for service providers based
on their location. This could include the ability to search within a certain radius of the client’s
location.

FR3.5.7 - Auto-Suggestion: As clients type in the search bar, the system shall provide auto-
suggestions based on popular searches and existing service categories or providers.

FR3.5.8 - Search History: The system shall keep a record of the client’s past searches. Clients shall be
able to view and repeat these searches easily.

FR3.5.9 - Error Handling: If a client’s search does not return any results, the system shall provide
helpful suggestions or alternatives.

3.6 Client can view provider’s profile

FR3.6.1 - Provider Profile Access: The system shall allow clients to access the profiles of service
providers.

FR3.6.2 - Display Provider Information: The system shall display detailed information about the
service provider, including their expertise, experience, certifications, and reviews.

FR3.6.3 - Display Provider Availability: The system shall display the service provider’s
availability, allowing clients to see when the provider is available for bookings.

FR3.6.4 - Provider Rating and Reviews: The system shall display the ratings and reviews given
to the service provider by other clients.

FR3.6.5 - Provider Contact Information: The system shall provide a means for clients to contact
the service provider securely through the platform.

FR3.6.6 - Provider Service Details: The system shall display the services offered by the provider,
along with their pricing.

FR3.6.7 - Provider Profile Navigation: The system shall allow clients to easily navigate between
different sections of the provider’s profile.

FR3.6.8 - Provider Profile Update: The system shall update the provider’s profile in real-time to
reflect any changes made by the provider.

7
 3.7 Client can request quotes

FR3.7.1 - Quote Request Access: The system shall allow clients to request quotes from service
providers.

FR3.7.2 - Quote Request Form: The system shall provide a form for clients to fill out their
service needs, including the type of service, preferred date and time, and any specific requests
or instructions.

FR3.7.3 - Provider Selection for Quote: The system shall allow clients to select specific
providers to send the quote request to, or alternatively, send the request to all providers
matching the service needs.

FR3.7.4 - Quote Request Submission: The system shall allow clients to submit the quote
request, which will then be sent to the selected providers.

FR3.7.5 - Quote Response: The system shall notify clients when a provider responds to the
quote request with a price and additional information.

FR3.7.6 - Quote Review: The system shall allow clients to review all received quotes, compare
them, and select the most suitable one.

FR3.7.7 - Quote History: The system shall keep a record of all quote requests and responses for
future reference.

3.8 Client can book services

FR3.8.1 - Service Selection: The system shall allow clients to select the service they want to book
from a list of available services.

FR3.8.2 - Provider Selection: The system shall allow clients to select a service provider based on
their preferences such as location, availability, expertise, ratings, and pricing.

FR3.8.3 - Booking Form: The system shall provide a form for clients to specify details of the booking
such as preferred date and time, and any specific requests or instructions.

FR3.8.4 - Booking Confirmation: The system shall allow clients to review the details of the booking
and confirm the booking.

FR3.8.5 - Booking Notification: The system shall notify the selected service provider about the
booking request.

FR3.8.6 - Booking Status: The system shall allow clients to view the status of their booking (e.g.,
pending, confirmed, completed).

FR3.8.7 - Booking Cancellation: The system shall allow clients to cancel the booking if needed,
subject to the cancellation policy.

FR3.8.8 - Booking History: The system shall keep a record of all bookings made by the client for
future reference.

8
 3.9 Client can manage Profile

FR3.9.1 - Profile Creation: The system shall provide a feature for clients to create their profiles. This
profile shall include information such as name, contact details, and payment methods.

FR3.9.2 - Profile Editing: The system shall allow clients to edit their profiles. Clients shall be able to
update their information such as name, contact details, and payment methods.

FR3.9.3 - Profile Deletion: The system shall allow clients to delete their profiles. Upon deletion, all
personal data associated with the client shall be removed from the system.

FR3.9.4 - Profile Viewing: The system shall allow clients to view their profiles. The profile view shall
display all the client’s information.

FR3.9.5 - Profile Privacy: The system shall ensure the privacy of client profiles. Only the client shall
be able to view their personal information.

FR3.9.6 - Profile Security: The system shall ensure the security of client profiles. All personal data
shall be stored securely to prevent unauthorized access.

FR3.9.7 - Profile Verification: The system shall provide a feature for clients to verify their profiles.
Verified profiles shall have a visible mark indicating their verified status.

FR3.9.8 - Profile Preferences: The system shall allow clients to set their preferences in their profiles.
These preferences shall include notification settings, privacy settings, and more.

3.10 Payment Method for Client

FR3.10.1 - Payment Method Selection: The system shall provide a feature for clients to select their
preferred payment method. This could include credit/debit cards, digital wallets, or bank transfers.

FR3.10.2 - Payment Processing: The system shall process payments securely. It shall communicate with
the payment gateway to authorize and complete transactions.

FR3.10.3 - Payment Confirmation: The system shall provide a confirmation to the client once the
payment is successful. This confirmation shall include details of the transaction.

FR3.10.4 - Payment History: The system shall maintain a record of all past payments made by the client.
Clients shall be able to view this history at any time.

FR3.10.5 - Invoice Generation: The system shall generate an invoice for each payment made. This
invoice shall include details of the service, the amount paid, and the date of payment.

FR3.10.6 - Error Handling: The system shall handle payment errors effectively. If a payment fails, the
system shall provide a clear error message to the client and suggest possible solutions.

FR3.10.7 - Refunds: The system shall handle refund requests from clients. It shall communicate with the
payment gateway to process refunds.

FR3.10.8 - Security: The system shall ensure the security of payment information. It shall comply with all
relevant security standards to protect client data.

9
 3.11 Update Rating and Reviews in Provider Profile

FR3.11.1 - Rating Submission: The system shall provide a feature for clients to submit ratings for service
providers. Clients should be able to rate the service on a predefined scale.

FR3.11.2 - Review Submission: The system shall provide a feature for clients to submit reviews for
service providers. Clients should be able to write a detailed review of the service they received.

FR3.11.3 - Rating and Review Display: The system shall display the ratings and reviews submitted by
clients on the service provider’s profile.

FR3.11.4 - Rating and Review Update: The system shall allow clients to update their ratings and reviews.
Clients should be able to edit or delete their previous ratings and reviews.

FR3.11.5 - Rating and Review Verification: The system shall verify the authenticity of the ratings and
reviews. It should ensure that only clients who have availed the service can rate and review it.

FR3.11.6 - Provider Response: The system shall allow service providers to respond to the reviews.
Providers should be able to address client concerns or thank them for positive reviews.

FR3.11.7 - Rating and Review Aggregation: The system shall aggregate the ratings to provide an overall
score for the service provider.

3.12 Service Provider can Track Earnings

FR3.12.1 - Earnings Dashboard: The system shall provide a dashboard where service providers can
view their earnings.

FR3.12.2 - Earnings Breakdown: The system shall provide a detailed breakdown of earnings,
including earnings per service, tips, and bonuses.

FR3.12.3 - Earnings History: The system shall allow service providers to view their earnings history.

FR3.12.4 - Earnings Filter: The system shall allow service providers to filter their earnings based on
date, service type, and client.

FR3.12.5 - Earnings Report Generation: The system shall allow service providers to generate
earnings reports for a specified period.

FR3.12.6 - Earnings Notifications: The system shall notify service providers when they receive
payment for a service.

FR3.12.7 - Earnings Withdrawal: The system shall allow service providers to withdraw their earnings.

10
 3.13 Service Provider can withdraw amount

FR3.13.1 - Withdrawal Request: The system shall allow service providers to request a withdrawal of
their earnings.

FR3.13.2 - Withdrawal Amount Input: The system shall provide an input field where service
providers can specify the amount they wish to withdraw.

FR3.13.3 - Withdrawal Method Selection: The system shall allow service providers to select their
preferred withdrawal method.

FR3.13.4 - Withdrawal Confirmation: The system shall confirm the withdrawal request and provide
an estimated time for the transaction to be processed.

FR3.13.5 - Withdrawal History: The system shall allow service providers to view their withdrawal
history.

FR3.13.6 - Withdrawal Notifications: The system shall notify service providers when their
withdrawal has been processed.

FR3.13.7 - Withdrawal Limits: The system shall enforce withdrawal limits to ensure financial
security.

3.14 Client can communicate with service providers

FR3.14.1: System should let the client to communicate with the service provider by sending
messages.

FR3.14.2: System should let the client to communicate with the service provider by making calls.

3.15 Client can rate and review service provider

FR3.15.1: System should let the user to rate the service provider.

FR3.15.2: System should let the user to review the service provider

1.15 Service provider can manage schedule.

11
FR1.15.1: System should let the service provider to view all upcoming and past bookings in a
dedicated calendar.

FR1.15.2: System should let the service provider to accept booking requests from clients

FR1.15.3: System should let the service provider to reject booking requests

FR1.15.4: System should let the service provider to specify potential reasons for booking rejections

FR1.15.5: System should let the service provider to cancel confirmed bookings with justification
(optional).

12