Changes between Version 12 and Version 13 of Normalization

Timestamp:

08/30/26 08:06:01 (8 days ago)

Author:

232012

Comment:

--

Normalization

@@ -132 +132 @@
 
 
-==== **1. PRODUCT(product_id, release_id, format, price, product_description, stock)**
+==== 1. PRODUCT(product_id, format, price, product_description, stock)
 
 
@@ -139 +139 @@
 
 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, 
+      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}
+      release_artist_type, song_ordinal, product_id}
 }}}
 
 **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}
+**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 = R1 - {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}
+      artist_id, release_id, title, record_label, genre, release_date, cover_photo, duration, album_id, song_id, song_name, song_duration,
+      product_id, 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.
-
+**Dependency preservation:** The dependency {{{artist_id → artist_name, artist_description, artist_photo}}} is preserved in the new ''ARTIST'' relation.
+
+
+==== 3. RELEASE(release_id, title, record_label, genre, release_date, cover_photo, duration)
+
+{{{
+R3 = R2 - {title, record_label, genre, release_date, cover_photo, duration}
+
+R3 = {user_id, email, username, password, date_created, shipping_address, telephone_number, admin_type, discount_percentage, points_collected,
+      artist_id, release_id, album_id, song_id, song_name, song_duration, product_id, 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 {{{release_id}}}.
+
+**Dependency preservation:** The dependency {{{release_id → title, record_label, genre, release_date, cover_photo}}} is preserved in the new ''RELEASE'' relation.
+
+==== 4. SONG(song_id, song_name, song_duration)
+
+{{{
+R4 = R3 - {song_name, song_duration}
+
+R4 = {user_id, email, username, password, date_created, shipping_address, telephone_number, admin_type, discount_percentage, points_collected,
+      artist_id, release_id, album_id, song_id, product_id, 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 {{{song_id}}}.
+
+**Dependency preservation:** The dependency {{{song_id → song_name, song_duration}}} is preserved in the new ''SONG'' relation.
+
+==== 5. MODIFICATION(modification_id, admin_id, date_modified, type_of_modification, discount)
+
+{{{
+R5 = R4 - {admin_id, date_modified, type_of_modification, discount}
+
+R5 = {user_id, email, username, password, date_created, shipping_address, telephone_number, admin_type, discount_percentage, points_collected,
+      artist_id, release_id, album_id, song_id, product_id, order_id, payment_method, purchase_date, points_earned, points_used, status,
+      modification_id, 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 {{{modification_id}}}.
+
+**Dependency preservation:** The dependency {{{modification_id → admin_id, date_modified, type_of_modification, discount}}} is preserved in the new ''MODIFICATION'' relation.
+
+==== 6. ORDER(order_id, user_id, payment_method, purchase_date, points_earned, points_used, status)
+
+{{{
+R6 = R5 - {payment_method, purchase_date, points_earned, points_used, status}
+
+R6 = {user_id, email, username, password, date_created, shipping_address, telephone_number, admin_type, discount_percentage, points_collected,
+      artist_id, release_id, album_id, song_id, product_id, order_id, modification_id, 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 {{{order_id}}}.
+
+**Dependency preservation:** The dependency {{{order_id → user_id, payment_method, purchase_date, points_earned, points_used, status}}} is preserved in the new ''ORDER'' relation.
+
+==== 7. USER(user_id, email, username, password, date_created, shipping_address, telephone_number)
+
+{{{
+R7 = R6 - {email, username, password, date_created, shipping_address, telephone_number}
+
+R7 = {user_id, admin_type, discount_percentage, points_collected, artist_id, release_id, album_id, song_id, product_id, order_id,
+      modification_id, 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 {{{user_id}}}.
+
+**Dependency preservation:** The dependency {{{user_id → email, username, password, date_created, shipping_address, telephone_number}}} is preserved in the new ''USER'' relation.
+
+==== 8. ORDER_PRODUCTS(order_id, product_id, price_at_purchase, quantity)
+
+{{{
+R8 = R7 - {price_at_purchase, quantity}
+
+R8 = {user_id, admin_type, discount_percentage, points_collected, artist_id, release_id, album_id, song_id, product_id, order_id,
+      modification_id, wishlist_id, added_at, release_ordinal, release_artist_type, song_ordinal}
+}}}
+
+**Lossless join:** The original relation can be reconstructed through a join using {{{order_id, product_id}}}.
+
+**Dependency preservation:** The dependency {{{(order_id, product_id) → price_at_purchase, quantity}}} is preserved in the new ''ORDER_PRODUCTS'' relation.
+
+==== 9. WISHLIST_PRODUCTS(wishlist_id, product_id, added_at)
+
+{{{
+R9 = R8 - {added_at}
+
+R9 = {user_id, admin_type, discount_percentage, points_collected, artist_id, release_id, album_id, song_id, product_id, order_id,
+      modification_id, wishlist_id, release_ordinal, release_artist_type, song_ordinal}
+}}}
+
+**Lossless join:** The original relation can be reconstructed through a join using {{{wishlist_id, product_id}}}.
+
+**Dependency preservation:** The dependency {{{(wishlist_id, product_id) → added_at}}} is preserved in the new ''WISHLIST_PRODUCTS'' relation.
+
+==== 10. RELEASE_ARTISTS(release_id, artist_id, release_ordinal, release_artist_type)
+
+{{{
+R10 = R9 - {release_ordinal, release_artist_type}
+
+R10 = {user_id, admin_type, discount_percentage, points_collected, artist_id, release_id, album_id, song_id, product_id, order_id,
+       modification_id, wishlist_id, song_ordinal}
+}}}
+
+**Lossless join:** The original relation can be reconstructed through a join using {{{release_id, artist_id}}}.
+
+**Dependency preservation:** The dependency {{{(release_id, artist_id) → release_ordinal, release_artist_type}}} is preserved in the new ''RELEASE_ARTISTS'' relation.
+
+==== 11. SONG_ARTISTS(song_id, artist_id, song_ordinal)
+
+{{{
+R11 = R10 - {song_ordinal}
+
+R11 = {user_id, admin_type, discount_percentage, points_collected, artist_id, release_id, album_id, song_id, product_id, order_id,
+       modification_id, wishlist_id}
+}}}
+
+**Lossless join:** The original relation can be reconstructed through a join using {{{song_id, artist_id}}}.
+
+**Dependency preservation:** The dependency {{{(song_id, artist_id) → song_ordinal}}} is preserved in the new ''SONG_ARTISTS'' relation.