Changes between Version 10 and Version 11 of Normalization


Ignore:
Timestamp:
08/29/26 06:09:38 (9 days ago)
Author:
232012
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Normalization

    v10 v11  
    116116{{{R ∈ 1NF}}}: The universal relation R is in 1NF because all attributes contain atomic values and there are no repeating groups.
    117117
    118 {{{R ∉ 2NF}}}: The candidate key of R is:
    119 
    120                  **K = {order_id, product_id, artist_id, song_id, modification_id, album_id}**
    121 
    122 {{{#!div style="text-align: justify; width: 100%;"
    123                  Since K is a composite key, we must check for partial functional dependencies in order to determine whether R satisfies 2NF.
    124 }}}
     118{{{R ∉ 2NF}}}: Since candidate key of R: **K = {order_id, product_id, artist_id, song_id, modification_id, album_id}** is a composite key, we must check for partial functional dependencies in order to determine whether R satisfies 2NF.
    125119
    126120**Examples of a 2NF violation:**