Changes between Version 4 and Version 5 of UseCase003

Timestamp:

05/13/26 11:54:50 (2 weeks ago)

Author:

232012

Comment:

--

UseCase003

@@ -20 +20 @@
 1. User navigates to the store's catalog or search page to view available music.
 
-2. System retrieves the list of {{{Releases}}} from the database, including metadata such as {{{title}}}, {{{genre}}}, and {{{record_label}}}.
+2. System retrieves the list of Releases from the database, including metadata such as title, genre, and record_label.
 
-3. System matches each {{{Release}}} with its corresponding {{{Artist}}} to display the {{{artist_name}}}.
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT release_id, title, genre, record_label, release_date, cover_photo 
+FROM Release;
+}}}
+}}}
 
-4. System identifies the specific physical {{{Product/s}}} available for each release (such as Vinyl, CD, or Cassette) along with their current {{{price}}} and {{{stock levels}}}.
+3. System matches each Release with its corresponding Artist to display the artist_name.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT r.title, a.artist_name 
+FROM Release r
+JOIN Artist a ON r.artist_id = a.artist_id;
+}}}
+}}}
+
+4. System identifies the specific physical Product/s available for each release (such as Vinyl, CD, or Cassette) along with their current price and stock levels.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT release_id, format, price, stock 
+FROM Product 
+WHERE release_id = @current_release_id;
+}}}
+}}}
 
 5. System displays the results to the user, formatted by the release type (Album or Single) and featuring the {{{cover_photo}}}.
+
+{{{#!div style="margin-left: 20px;"
+{{{
+SELECT release_id, 'Album' AS type FROM Album
+UNION
+SELECT release_id, 'Single' AS type FROM Single;
 }}}
+}}}
+
+}}}