Changes between Version 1 and Version 2 of UseCase008

Timestamp:

05/13/26 14:58:36 (2 weeks ago)

Author:

232012

Comment:

--

UseCase008

@@ -11 +11 @@
 {{{#!div style="text-align: justify; width: 100%;"
 
-1. Admin selects an existing {{{Release}}} (Album or Single) for which they want to add a new physical version.
+1. Admin selects an existing Release (Album or Single) for which they want to add a new physical version.
 
-2. Admin enters the specific details for the new inventory item, including the {{{format}}} (e.g., Vinyl, CD, Cassette), the unit {{{price}}}, a brief {{{description}}}, and the initial {{{stock}}} quantity.
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT release_id, title 
+FROM Release;
+}}}
+}}}
 
-3. System validates that the provided information meets the required data formats and that the {{{product_id}}} is unique.
+2. Admin enters the specific details for the new inventory item, including the format (e.g., Vinyl, CD, Cassette), the unit price, a brief description, and the initial stock quantity.
 
-4. System creates a new entry in the {{{Product}}} table, establishing a "version of" relationship with the selected {{{release_id}}}.
+3. System validates that the provided information meets the required data formats and that the product_id is unique.
 
-5. System updates the catalog to include this new {{{Product}}}, making it visible and available for purchase on the corresponding release page.
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT COUNT(*) 
+FROM Product 
+WHERE product_id = @new_product_id;
 }}}
+}}}
+
+4. System creates a new entry in the Product table, establishing a "version of" relationship with the selected release_id.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+INSERT INTO Product (release_id, format, price, description, stock) 
+VALUES (@selected_release_id, 'Vinyl', 3059, '180g Black Vinyl', 50);
+}}}
+}}}
+
+5. System updates the catalog to include this new Product, making it visible and available for purchase on the corresponding release page.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT * 
+FROM Product 
+WHERE release_id = @selected_release_id;
+}}}
+}}}
+
+}}}