Changes between Version 6 and Version 7 of Normalization

Timestamp:

08/29/26 06:01:25 (9 days ago)

Author:

232012

Comment:

--

Normalization

@@ -110 +110 @@
 
 
-== 1NF decomposition
+== Normal Form of R Before Decomposition
 
 {{{#!div style="text-align: justify; width: 100%;"
-The universal relation R is in 1NF because all attributes contain atomic values and there are no repeating groups.
 
-{{{R ∈ 1NF}}}
+{{{R ∈ 1NF}}}: The universal relation R is in 1NF because all attributes contain atomic values and there are no repeating groups.
+
+{{{R ∉ 2NF}}}: The candidate key of R is:
+
+               **K = {order_id, product_id, artist_id, song_id, modification_id, album_id}**
+
+               Since K is a composite key, we must check for partial functional dependencies in order to determine whether R satisfies 2NF.
+
+**Example of a 2NF violation:**
+
+product_id → release_id, format, price, product_description, stock
+artist_id → artist_name, artist_description, artist_photo
+song_id → song_name, song_duration
+
+In each case, a proper subset of the candidate key determines non-prime attributes. Therefore, R contains partial functional dependencies
+and is not in 2NF.
+
 }}}