Changes between Version 1 and Version 2 of Normalization


Ignore:
Timestamp:
08/28/26 07:39:44 (10 days ago)
Author:
232012
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v1 v2  
    1 Normalization
    2 De-normalized database form
    3 Functional dependencies
    4 Candidate keys and primary key
    5 1NF decomposition
     1= Normalization
     2
     3== De-normalized database form
     4
     5First, we combine every attribute in the entire model into one single relation - **Universal Relation R**.
     6
     7{{{
     8R(
     9    user_id,
     10    email,
     11    username,
     12    password,
     13    date_created,
     14    shipping_address,
     15    telephone_number,
     16    admin_type,
     17    discount_percentage,
     18    points_collected,
     19    artist_id,
     20    artist_name,
     21    artist_description,
     22    artist_photo,
     23    release_id,
     24    title,
     25    record_label,
     26    genre,
     27    release_date,
     28    cover_photo,
     29    duration,
     30    song_id,
     31    song_name,
     32    song_duration,
     33    product_id,
     34    format,
     35    price,
     36    product_description,
     37    stock,
     38    order_id,
     39    payment_method,
     40    purchase_date,
     41    points_earned,
     42    points_used,
     43    status,
     44    modification_id,
     45    date_modified,
     46    type_of_modification,
     47    discount,
     48    wishlist_id,
     49    quantity,
     50    price_at_purchase,
     51    added_at,
     52    release_ordinal,
     53    type,
     54    song_ordinal
     55)
     56}}}
     57
     58== Functional dependencies
     59
     60{{{
     61FD01: user_id → email, username, password, date_created, shipping_address, telephone_number
     62FD02: email → user_id
     63FD03: username → user_id
     64FD04: user_id → admin_type, discount_percentage
     65FD05: user_id → points_collected
     66FD06: artist_id → artist_name, artist_description, artist_photo
     67FD07: release_id → title, record_label, genre, release_date, cover_photo, duration
     68FD08: song_id → song_name, song_duration
     69FD09: product_id → release_id, format, price, product_description, stock
     70FD10: order_id → user_id, payment_method, purchase_date, points_earned, points_used, status
     71FD11: modification_id → admin_id, date_modified, type_of_modification, discount
     72FD12: wishlist_id → user_id
     73FD13: user_id → wishlist_id
     74FD14: (order_id, product_id) → price_at_purchase, quantity
     75FD15: (wishlist_id, product_id) → added_at
     76FD16: (release_id, artist_id) → release_ordinal, release_artist_type
     77FD17: (song_id, artist_id) → song_ordinal
     78}}}
     79
     80== Candidate keys and primary key
     81
     82
     83
     84== 1NF decomposition
    685…
    786
    8 2NF decomposition
     87== 2NF decomposition
    988…
    1089
    11 3NF decomposition
     90== 3NF decomposition
    1291…
    1392
    14 BCNF if possible
     93== BCNF if possible
    1594…
    1695
    17 Final result and discussion
    18 Normalized relational model
    19 Discussion
     96== Final result and discussion