Changes between Version 1 and Version 2 of UseCase09

Timestamp:

05/17/26 20:00:37 (8 days ago)

Author:

181201

Comment:

--

UseCase09

@@ -6 +6 @@
 
 '''Description:'''
-The Admin moderates the platform by reviewing the user behavior. If a user is problematic, the admin can completely remove them from the platform. Because the database uses CASCADE delete rules, deleting the user automatically cleans up their pets, bookings, and reviews.
+The Admin moderates the platform by reviewing user behavior. If a user is problematic, the admin can completely remove them. To satisfy database constraints, the system first clears their active bookings, then deletes the user (which cascades to delete their pets and reviews).
 
 '''Scenario:'''
@@ -17 +17 @@
 ORDER BY username ASC;
 }}}
- 3. Admin clicks the "Delete User" button next to a specific user they want to remove.
- 4. System executes the deletion, cascading to all related tables:
+ 3. Admin clicks the "Delete" button next to a specific user.
+ 4. System executes the deletion cleanly:
 {{{
 #!sql
-DELETE FROM users 
-WHERE username = 'owner_marko';
+DELETE FROM bookings WHERE owner_id = (SELECT user_id FROM users WHERE username = 'owner_marko');
+DELETE FROM users WHERE username = 'owner_marko';
 }}}