Changes between Version 1 and Version 2 of UseCase009

Timestamp:

05/13/26 15:01:25 (2 weeks ago)

Author:

232012

Comment:

--

UseCase009

@@ -11 +11 @@
 {{{#!div style="text-align: justify; width: 100%;"
 
-1. Admin selects an existing {{{Product}}} from the inventory management interface that requires an update.
+1. Admin selects an existing Product from the inventory management interface that requires an update.
 
-2. System retrieves the current data for the {{{Product}}}, including {{{price}}}, {{{stock}}}, {{{description}}}, and {{{format}}}.
+2. System retrieves the current data for the Product, including price, stock, description, and format.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT product_id, format, price, stock, description, release_id
+FROM Product
+WHERE product_id = @selected_product_id;
+}}}
+}}}
 
 3. Admin enters the new values for the attributes that need to be modified.
@@ -19 +27 @@
 4. System validates the updated information to ensure it adheres to the required data formats (e.g., non-negative values for price and stock).
 
-5. System updates the corresponding record in the {{{Product}}} table with the new data.
+5. System updates the corresponding record in the Product table with the new data.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+UPDATE Product
+SET 
+    price = @new_price,
+    stock = @new_stock,
+    description = @new_description,
+    format = @new_format
+WHERE product_id = @selected_product_id;
+}}}
+}}}
 
 6. System confirms the successful modification to the admin and updates the product information across the public catalog immediately.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT * 
+FROM Product 
+WHERE product_id = @selected_product_id;
 }}}
+}}}
+
+}}}