Changes between Version 11 and Version 12 of Normalization

Timestamp:

08/30/26 07:00:28 (8 days ago)

Author:

232012

Comment:

--

Normalization

@@ -128 +128 @@
 
 }}}
+
+== 2NF Decomposition
+
+
+==== **1. PRODUCT(product_id, release_id, format, price, product_description, stock)**
+
+
+{{{
+R1 = R - {release_id, format, price, product_description, stock}
+
+R1 = {user_id, email, username, password, date_created, shipping_address, telephone_number, admin_type, discount_percentage, points_collected,
+      artist_id, artist_name, artist_description, artist_photo, release_id, title, record_label, genre, release_date, cover_photo, duration,                                             
+      album_id, song_id, song_name, song_duration, order_id, payment_method, purchase_date, points_earned, points_used, status, modification_id, 
+      admin_id, date_modified, type_of_modification, discount, wishlist_id, quantity, price_at_purchase, added_at, release_ordinal,
+      release_artist_type, song_ordinal}
+}}}
+
+**Lossless join:** The original relation can be reconstructed through a join using {{{product_id}}}.
+
+**Dependency preservation:** The dependency {{{product_id → release_id, format, price, product_description, stock}}} is preserved in the new PRODUCT relation.
+
+
+==== **2. ARTIST(artist_id, artist_name, artist_description, artist_photo)**
+
+
+{{{
+R2 = R - {artist_name, artist_description, artist_photo}
+
+R2 = {user_id, email, username, password, date_created, shipping_address, telephone_number, admin_type, discount_percentage, points_collected,
+      artist_id, release_id, title, record_label, genre, release_date, cover_photo, duration, album_id, song_id, song_name, song_duration,                                             
+      product_id, format, price, product_description, stock, order_id, payment_method, purchase_date, points_earned, points_used, status, 
+      modification_id, admin_id, date_modified, type_of_modification, discount, wishlist_id, quantity, price_at_purchase, added_at, release_ordinal,
+      release_artist_type, song_ordinal}
+}}}
+
+**Lossless join:** The original relation can be reconstructed through a join using {{{artist_id}}}.
+
+**Dependency preservation:** The dependency {{{artist_id → artist_name, artist_description, artist_photo}}} is preserved in the new ARTIST relation.
+