Changes between Version 16 and Version 17 of Normalization

Timestamp:

09/01/26 01:50:59 (7 days ago)

Author:

232012

Comment:

--

Normalization

@@ -348 +348 @@
 }}}
 
-== 3NF
+== 3NF Decomposition
+
+{{{#!div style="text-align: justify; width: 100%;"
+Listed bellow are the relations obtained after the 2NF decomposition as they are examined for transitive dependencies to determine whether or not a 3NF Decomposition is needed.
 
 ==== PRODUCT
@@ -463 +466 @@
 }}}
 {{{user_id}}} and {{{wishlist_id}}} determine each other, meaning each attribute is independently a candidate key. Both determinants are therefore superkeys, and no transitive dependency exists. **No decomposition needed**.
-
-== BCNF
+}}}
+
+== BCNF Decomposition
+
+{{{#!div style="text-align: justify; width: 100%;"
+Listed below are the relations obtained after the 3NF analysis, examined to determine whether every non-trivial functional dependency has a superkey as its determinant and whether further decomposition is required to achieve BCNF.
 
 The primary keys are bolded.
@@ -483 +490 @@
 14. WISHLIST(**wishlist_id**, user_id) → **satisfies BCNF**
 15. R15 = {**artist_id**, **album_id**, **song_id**, **product_id**, **order_id**, **modification_id**} → **satisfies BCNF**
+}}}