Changes between Initial Version and Version 1 of UseCase12

Timestamp:

05/08/26 03:19:14 (4 hours ago)

Author:

181201

Comment:

--

UseCase12

@@ +1 @@
+== Use-case 0012 - Search for Sitters by Service
+
+'''Initiating actor:''' Pet Owner
+
+'''Other actors:''' None
+
+'''Description:'''
+A Pet Owner needs a specific service and wants to find sitters who offer it. The system filters the registered sitters based on the service selected by the owner.
+
+'''Scenario:'''
+ 1. Pet Owner navigates to the "Find a Sitter" search page.
+ 2. System fetches all available services to populate the search dropdown:
+{{{
+#!sql
+SELECT type FROM services ORDER BY type ASC;
+}}}
+ 3. Owner selects "Dog Walking" from the dropdown and clicks "Search".
+ 4. System joins the tables to find sitters who offer that exact service:
+{{{
+#!sql
+SELECT u.user_id, u.first_name, u.last_name, u.email 
+FROM users u
+JOIN pet_sitters ps ON u.user_id = ps.user_id
+JOIN sitter_services ss ON ps.user_id = ss.sitter_id
+JOIN services s ON ss.service_id = s.service_id
+WHERE s.type = 'Dog Walking';
+}}}