Requirements for application

[sevenmatt7]

NEED TO FINALISE ER DIAGRAM AND DATABASE SCHEMA BEFORE IMPLEMENTING ANYMORE FEATURES!!!!!!!!!!!!!!!!!!!

Requirement	Implementation	To be completed by
✅ The PCS application allows pet owner to search for care takers for their pets for certain periods of time
✅ The application supports at least three kinds of users: Pet Owner, Caretaker, and PCS Administrator.	Support registration and sign up for each type of user	Matt
✅ Note that the Pet Owner and Care Taker may use the same account and when they are mentioned as one, we will use the term User.	User can register as both caretaker and petowner	Matt
✅ Each User must have a profile	Have a profile page to show relevant information pertaining to each user	Matt
✅ Additionally, we want the Pet to also have a profile.	Pets have their cards to show their relevant information	Matt
✅ Pet Owner can browse or search for Care Taker and bid for their services	Basic homepage done	Gy
✅ Pet are classified into categories (e.g., cats, dogs, big dogs, lizards, etc.) to facilitate browsing	Need to create filter on homepage to show how many pets in each category	Gy
✅ They may also have special requirements related to how they need to be taken care of (e.g., daily walk, types of food, etc.)	Need to also create filter on homepage to show how many pets in each category	Gy
✅ Care Taker can advertise their availability. This include the days they are available, the kind of pets they can take care, their daily price for each kind of Pet, etc.	Basic availability registration page set up	Matt
✅ Caretaker should not take care of pets they cannot care for but may take care of more than one pet at any given time.	Need a filter to only show jobs offered that fit with caretakers specs	Matt
✅ Both the Pet Owner and Care Taker should agree on how to transfer the Pet	Currently, this agreement is one sided so probably need to change so caretaker can also change
✅ The successful bidder could either be chosen by the Care Taker or automatically selected by the system based on some criteria.	Caretaker can choose which bid to accept	Matt
✅ The cost of caring for a Pet is the number of days times the daily price stated by the Care Taker.	Need to change so no bidding price	Matt
✅ Once selected by the Care Taker, the Pet Owner must pay for the amount upfront either by pre registered credit card or paying cash	Need to have the option in the requestService	Matt
❌ NEED TO BE ABLE TO REGISTER CREDIT CARD	Need to have the option in the requestService	Matt
✅ At the end of the care period, the Pet Owner can post a review on and give rating to the Care Taker.	There is a check at the frontend to make sure the caretaker can only complete job on the end date or after	Matt
✅ The review and rating will only be for the specific transaction.	Yes this is done	Matt
✅ Pet Owner may submit multiple review/rating for a Care Taker if the Care Taker has taken care of the Pet Owner’s Pet multiple times, including for the same pet	Yes this is done	Matt
✅ reviews will be available to all User.	Done	Matt
✅ Each Care Taker can be either a full-time or a part-time employee.	only can either be part time or full time as specified in the attribute employment type
✅ Each full-time Care Taker must work for a minimum of 2 × 150 consecutive days a year (since it includes weekends, so there are plenty of leave days available). A full-time Care Taker is treated as available until they apply for leave.	Constraints not done yet on backend	Matt
✅ A full-time Care Taker are treated as available until they apply for leave.	Already set	Josh
✅ Caretakers cannot apply for leave if there is at least one Pet under their care.	Constraints not done yet on backend	Matt
✅ Full-time Caretaker has a limit of up to 5 Pet at any one time.	implemented as trigger	Matt
✅ When bid by any Pet Owner, a full-time Care Taker will always accept the job immediately if possible	Constraints not done yet on backend
✅ each part-time Care Taker, they should be able to specify their availability for the current year and the next year. For instance, on 1 January 2020, a part-time Care Taker can already specify their availability until 31 December 2021.	Constraints not done yet on backend	Gy
✅ part-time Care Taker cannot take care of more than 2 Pet unless they have a good rating (4 out of 5)	Implemented in trigger	Matt
✅ part-time caretakers they cannot have more than 5 Pet regardless of rating		Matt
✅ base daily price for a full-time Care Taker is already specified by PCS Administrator for each pet type.	how can the PCSAdmin change the base daily price for full time caretaker?	Matt
✅ price increases with the rating of the Care Taker but will never be below the base price	Constraints not done yet on backend	Glen
✅ The salary of full-time Care Taker depends on how many Pet are taken care of in a given month for how many days.	Need to implement this on both front end and back end	Glen
✅ A full-time Care Taker will receive a salary of $3000 per month for up to 60 pet-day.		Glen
✅ For any excess pet-day, they will receive 80% of their price as bonus	Need to implement this on both front end and back end	Glen
✅ For part-time Care Taker, the PCS will take 25% of their price as payment (i.e. the Care Taker receives 75% of their stated price).	Need to implement this on both front end and back end	Glen
✅ Your application must contain at least 3 appropriate applications of triggers.	not done yet on backend	Josh
(a) Update the Offers_Services available dates whenever the condition of 5 pets jobs in the same period has been met.		Sean
✅ (b) Update avg_rating and no_of_reviews for caretaker profile after every review submission		Matt
(c)
✅ Support the creation/deletion/update of data for the different users (Pet Owner, Care Taker, and PCS Administrator).	Currently, no page that allows users to change details about them (pet owners and caretakers)	Gy
✅ Support deletion of accounts	Need to implement this on both front end and back end	Gy
✅ Support data access for the different users (e.g., Pet Owner can view reviews of Care Taker, their own past orders, etc.; Care Taker can see their review, their past jobs, their salary, etc	not done yet on backend
✅ Support the browsing of summary information for PCS Administrator. For instance, it can be one of the following:		Sean
(a) Total number of Pet taken care of in the month.
(b) Total salary to be paid to all Care Taker for the given month.
(c) The month with the highest number of jobs.
(d) The underperforming 1 full-time Care Taker.
(e) etc.
✅ Support the browsing of summary information for Care Taker. For instance, it can be one of the following:		Matt
(a) Total number of pet-day this month.
(b) Their expected salary for this month.
(c) etc.
✅ Support the browsing of summary information for Pet Owner. For instance, it can be one of the following:		Gy
(a) All Care Taker in their area (if information is available).
(b) Other Pet Owner nearby.
(c) Their Pet information.
(d) etc.
✅ your application’s database should be loaded with reasonably large tables.	Implemented with data dump	Matt
✅ Database has at least 1000 records of both Care Taker and Pet Owner combined.		Matt

The final project deliverables will be at the end of Week 12, with extension given on a case-by-case

basis.

1. Realistic ER data model with corresponding relational schema.
2. Applicable interesting queries that captures important business decision.
3. Highly polished user interface.
4. Well designed video (e.g., think of it like some mini promo video).