Changes between Version 14 and Version 15 of Normalization

Timestamp:

08/30/26 08:52:18 (8 days ago)

Author:

232012

Comment:

--

Normalization

@@ -131 +131 @@
 == 2NF Decomposition
 
-
+{{{#!div style="text-align: justify; width: 100%;"
 ==== 1. PRODUCT(product_id, format, price, product_description, stock)
 
@@ -289 +289 @@
 
 * **Dependency preservation:** The dependency {{{(song_id, artist_id) → song_ordinal}}} is preserved in the new ''SONG_ARTISTS'' relation.
+
+==== 12. ADMIN(user_id, admin_type, discount_percentage)
+
+{{{
+R12 = R11 - {admin_type, discount_percentage}
+
+R12 = {user_id, 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 {{{user_id}}}.
+
+* **Dependency preservation:** The dependency {{{user_id → admin_type, discount_percentage}}} is preserved in the new ''ADMIN'' relation.
+
+==== 13. CONSUMER(user_id, points_collected)
+
+{{{
+R13 = R12 - {points_collected}
+
+R13 = {user_id, 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 {{{user_id}}}.
+
+* **Dependency preservation:** The dependency {{{user_id → points_collected}}} is preserved in the new ''CONSUMER'' relation.
+
+==== 14. WISHLIST(user_id, wishlist_id)
+
+{{{
+R14 = R13 - {wishlist_id}
+
+R14 = {user_id, artist_id, release_id, album_id, song_id, product_id, order_id, modification_id}
+}}}
+
+* **Lossless join:** The original relation can be reconstructed through a join using {{{user_id}}}.
+
+* **Dependency preservation:** The dependencies {{{user_id → wishlist_id}}} and {{{wishlist_id → user_id}}} are preserved in the new ''WISHLIST'' relation.
+
+==== 15. Removing Remaining Partial Dependencies
+
+Two non-prime attributes remain:
+
+1. {{{order_id → user_id}}}
+2. {{{product_id → release_id}}}
+
+Since {{{order_id}}} and {{{product_id}}} are proper subsets of the candidate key, these are still partial dependencies. However, these dependencies are already represented in ''ORDER'' and ''PRODUCT''.
+
+{{{
+R15 = R14 - {user_id, release_id}
+
+R15 = {artist_id, release_id, album_id, song_id, product_id,
+       order_id, modification_id}
+}}}
+
+* **Lossless join:** The removed {{{user_id}}} can be recovered through the existing ''ORDER'' relation using {{{order_id}}} and the removed {{{release_id}}} can be recovered through the existing ''PRODUCT'' relation using {{{product_id}}}.
+
+* **Dependency preservation:** The dependency {{{order_id → user_id}}} remains preserved in the existing ''ORDER'' relation and the dependency {{{product_id → release_id}}} remains preserved in the existing ''PRODUCT'' relation.
+
+}}}