Changes between Version 7 and Version 8 of Normalization


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

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v7 v8  
    118118{{{R ∉ 2NF}}}: The candidate key of R is:
    119119
    120                **K = {order_id, product_id, artist_id, song_id, modification_id, album_id}**
     120                 **K = {order_id, product_id, artist_id, song_id, modification_id, album_id}**
    121121
    122                Since K is a composite key, we must check for partial functional dependencies in order to determine whether R satisfies 2NF.
     122                 Since K is a composite key, we must check for partial functional dependencies in order to determine whether R satisfies 2NF.
    123123
    124 **Example of a 2NF violation:**
     124**Examples of a 2NF violation:**
    125125
    126 product_id → release_id, format, price, product_description, stock
    127 artist_id → artist_name, artist_description, artist_photo
    128 song_id → song_name, song_duration
     126* {{{product_id → release_id, format, price, product_description, stock}}}
     127* {{{artist_id → artist_name, artist_description, artist_photo}}}
     128* {{{song_id → song_name, song_duration}}}
    129129
    130130In each case, a proper subset of the candidate key determines non-prime attributes. Therefore, R contains partial functional dependencies