Changes between Version 25 and Version 26 of Normalization


Ignore:
Timestamp:
07/16/26 08:48:17 (10 days ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v25 v26  
    55Below is an example of a denormalized table representing all information in one large relation. Notice that several columns contain multiple values (images, colors, addresses, products, etc.), which violates First Normal Form.
    66
    7 ||=// order_num =||=// client_name =||=// client_email =||=// delivery_address =||=// product_code =||=// product =||=// product_images =||=// product_colors =||=// product_price =||=// availability =||=// weight =||=// width_x_length_x_depth =||=// aprox_production_time =||=// delivery_cost =||=// order_quantity =||=// store_ID =||=// store_name =||=// date_of_founding =||=// physical_address =||=//store_email =||=// store_rating =||=// personal_SSN =||=// personal_type =||=// permission_type =||=// authorisation =||=// date_of_hire =||=// order_status =||=// last_date_mod =||=// payment_method =||=// discount =||=// review_comment =||=// order_rating =||=// review_last_mod_date =||=// request_num =||=// request_date_and_time =||=// request_problem =||=// notes_of_communication =||=// costumer_satisfaction =||=// report_date =||=// report_profit =||=// sales_trend =||=// marketing_growth =||=// owner_signature =||=// month_and_year =||=// monthly_profit =||=// change_date =||=//  changes =||=// worked_wage =||=// worked_pay_method =||=// worked_total_hours =||=//worked_week =||=// sells_discount =||=// approval_date =||=//exchange_monthly_profit =||=//exchange_date =||=//sales =||=//damages =||=//order_total =||
    8 || 0012025000001 || Marija Kostova || marija@yahoo.com || st.Turisticka 5, Bitola 7000, Macedonia || 00100001 || Handmade wooden chair with oak wood || chair.jpg || Brown || 700 || 50 || 2.5 || 30x20x10 || 10 || 50 || 1 || 001 || WoodCraft Skopje || 2015-03-12 || st.Ilindenska 45, Skopje 1000, Macedonia || contact@woodcraft.mk || 4.6 || 9876543210987 || Antonio Trajkovski || 1234567890123 || Marko Petrovski || EMPLOYEE || M.Petrovski || 2019-09-01 || delivered || 2025-12-02 14:30:00 || cash || 4.0 || Great quality, slightly late delivery || 4.0 || 2024-12-05 18:00:00 || 001112025001 || 2024-11-03 11:20:00 || Late delivery || Apologized and offered discount || 4.0 || 2024-11-30 23:59:59 || 125000.00 || Increasing || Stable growth || M.Petrovski || 2024-11-01 || 12500.00 || 2024-11-10 09:00:00 || FROM aprox_production_time=14 TO aprox_production_time=10 || 75 || hourly || 38 || 2025-11-24 - 2025-11-30 || 0.0 || 2025-12-01 09:56:30 || 38750.00 || 2024-12-01 08:00:00 || 52 || 750 || 700 ||
    9 || 0022025000001 || Ivan Stojanov || ivan@gmail.com || st.Partizanska 10, Skopje 1000, Macedonia || 00200002 || Decorative wall hanging made with beads || wall_hanging.jpg || White and Pink, Black and Gold, Orange, Green and Purpule || 199 || 100 || 0.75 || 40x40x1 || 14 || 0 || 2 || 002 || Fox Crochets || 2023-06-01 || st.Kej Makedonija 12, Ohrid 6000, Macedonia || ohrid@woodcraft.mk || 4.8 || 4567891234567 || Sara Vaneva || 4567891234567 || Sara Vaneva || BOSS || admin || — || placed order || 2025-12-01 10:15:00 || credit card ****6750 || 0.0 || Excellent craftsmanship || 5.0 || 2025-12-03 18:00:00 || 002122025001 || 2024-12-04 09:10:00 || Military discount || Discount approved || 5.0 || 2024-11-30 23:59:59 || 98000.00 || Stable || Moderate growth || S.Vaneva || 2024-11-01 || 8000.00 || — || — || 450 || weekly || 52 || 2025-11-24 - 2025-11-30 || 0.5 || 2025-12-03 13:06:12 || 26150 || 2024-12-01 08:00:00 || 40 || NULL || 398 ||
    10 || 0022025000002 || Ivan Stojanov || ivan@gmail.com || st.Partizanska 10, Skopje 1000, Macedonia || 00200001 || Heart crochet || crochet-heart-red.jpg, crochet-heart-blue.jpg || Blue, Red, Yellow, Green || 150 || 10 || 0.2 || 20x20x15 || 2 || 0 || 3 || 002 || Fox Crochets || 2023-06-01 || st.Kej Makedonija 12, Ohrid 6000, Macedonia || ohrid@woodcraft.mk || 4.8 || 4567891234567 || Sara Vaneva || 4567891234567 || Sara Vaneva || BOSS || admin || — || packaging || 2025-12-10 18:00:00 || PayPal account ******* || 0.0 || Beautiful handmade product || 5.0 || 2025-12-11 18:00:00 || — || — || — || — || — || 2024-11-30 23:59:59 || 98000.00 || Stable || Moderate growth || S.Vaneva || 2024-11-01 || 8000.00 || 2024-11-12 15:30:00 || Added new color || 450 || weekly || 52 || 2025-11-24 - 2025-11-30 || 0.0 || 2025-12-03 13:06:12 || 26150 || 2024-12-01 08:00:00 || 40 || NULL || 450 ||
    11 || 0012025000002 || Antoneta Mariovska || mariovskaantoneta@finki.ukim.mk || st.32 4, s.Cucer-Sandevo, Skopje, Macedonia || 00100001, 00200001 || Handmade wooden chair with oak wood, Heart crochet || chair.jpg, crochet-heart-red.jpg || Brown, Blue, Red || 850 || 50, 10 || 2.5, 0.2 || 30x20x10, 20x20x15 || 10, 2 || 50, 0 || 2 || 001,002 || WoodCraft Skopje & Fox Crochets || 2015-03-12; 2023-06-01 || st.Ilindenska 45, Skopje 1000, Macedonia; st.Kej Makedonija 12, Ohrid 6000, Macedonia || contact@woodcraft.mk; ohrid@woodcraft.mk || 4.6, 4.8 || 9876543210987; 4567891234567 || Antonio Trajkovski; Sara Vaneva || 1234567890123; 4567891234567 || Marko Petrovski; Sara Vaneva || EMPLOYEE; BOSS || M.Petrovski; admin || 2019-09-01; — || packaging || 2025-12-12 16:30:00 || credit card ****4582 || 5.0 || Very satisfied || 5.0 || 2025-12-14 12:00:00 || 003122025001 || 2024-12-10 14:00:00 || Packaging question || Explained packaging process || 5.0 || 2024-11-30 23:59:59 || 223000.00 || Increasing || Stable growth & Moderate growth || M.Petrovski; S.Vaneva || 2024-11-01 || 20500.00 || 2024-11-10 09:00:00; 2024-11-12 15:30:00 || FROM aprox_production_time=14 TO aprox_production_time=10; Added new color || 75; 450 || hourly; weekly || 38; 52 || 2025-11-24 - 2025-11-30 || 0.0; 0.0 || 2025-12-01 09:56:30; 2025-12-03 13:06:12 || 64900.00 || 2024-12-01 08:00:00 || 92 || 750 || 850 ||
    12 || 0022025000003 || Ivan Stojanov || ivan@gmail.com || st.Partizanska 10, Skopje 1000, Macedonia || 00200002 || Decorative wall hanging made with beads || wall_hanging.jpg || Black and Gold || 199 || 100 || 0.75 || 40x40x1 || 14 || 0 || 1 || 002 || Fox Crochets || 2023-06-01 || st.Kej Makedonija 12, Ohrid 6000, Macedonia || ohrid@woodcraft.mk || 4.8 || 4567891234567 || Sara Vaneva || 4567891234567 || Sara Vaneva || BOSS || admin || — || placed order || 2025-12-15 11:45:00 || credit card ****3281 || 2.0 || Wonderful decoration || 5.0 || 2025-12-20 15:00:00 || 004122025001 || 2024-12-16 10:30:00 || Shipping question || Tracking number provided || 5.0 || 2024-11-30 23:59:59 || 98000.00 || Stable || Moderate growth || S.Vaneva || 2024-11-01 || 8000.00 || — || — || 450 || weekly || 52 || 2025-11-24 - 2025-11-30 || 0.5 || 2025-12-03 13:06:12 || 26150.00 || 2024-12-01 08:00:00 || 40 || NULL || 195.02 ||
     7||=// order_num =||=// client_name =||=// client_email =||=// delivery_address =||=// product_code =||=// product =||=// product_images =||=// product_colors =||=// product_price =||=// availability =||=// weight =||=// width_x_length_x_depth =||=// aprox_production_time =||=// delivery_cost =||=// order_quantity =||=// store_ID =||=// store_name =||=// date_of_founding =||=// physical_address =||=//store_email =||=// store_rating =||=// personal_SSN =||=// personal_name =||=// permission_type =||=// authorisation =||=// date_of_hire =||=// order_status =||=// last_date_mod =||=// payment_method =||=// discount =||=// review_comment =||=// order_rating =||=// review_last_mod_date =||=// request_num =||=// request_date_and_time =||=// request_problem =||=// notes_of_communication =||=// costumer_satisfaction =||=// report_date =||=// report_profit =||=// sales_trend =||=// marketing_growth =||=// owner_signature =||=// month_and_year =||=// monthly_profit =||=// change_date =||=//  changes =||=// worked_wage =||=// worked_pay_method =||=// worked_total_hours =||=//worked_week =||=// sells_discount =||=// approval_date =||=//exchange_monthly_profit =||=//exchange_date =||=//sales =||=//damages =||=//order_total =||
     8|| 0012025000001 || Marija Kostova || marija@yahoo.com || st.Turisticka 5, Bitola 7000, Macedonia || 00100001 || Handmade wooden chair with oak wood || chair.jpg || Brown || 700 || 50 || 2.5 || 30x20x10 || 10 || 50 || 1 || 001 || WoodCraft Skopje || 2015-03-12 || st.Ilindenska 45, Skopje 1000, Macedonia || contact@woodcraft.mk || 4.6 || 9876543210987 || Antonio Trajkovski || EMPLOYEE || M.Petrovski || 2019-09-01 || delivered || 2025-12-02 14:30:00 || cash || 4.0 || Great quality, slightly late delivery || 4.0 || 2024-12-05 18:00:00 || 001112025001 || 2024-11-03 11:20:00 || Late delivery || Apologized and offered discount || 4.0 || 2024-11-30 23:59:59 || 125000.00 || Increasing || Stable growth || M.Petrovski || 2024-11-01 || 12500.00 || 2024-11-10 09:00:00 || FROM aprox_production_time=14 TO aprox_production_time=10 || 75 || hourly || 38 || 2025-11-24 - 2025-11-30 || 0.0 || 2025-12-01 09:56:30 || 38750.00 || 2024-12-01 08:00:00 || 52 || 750 || 700 ||
     9|| 0022025000001 || Ivan Stojanov || ivan@gmail.com || st.Partizanska 10, Skopje 1000, Macedonia || 00200002 || Decorative wall hanging made with beads || wall_hanging.jpg || White and Pink, Black and Gold, Orange, Green and Purpule || 199 || 100 || 0.75 || 40x40x1 || 14 || 0 || 2 || 002 || Fox Crochets || 2023-06-01 || st.Kej Makedonija 12, Ohrid 6000, Macedonia || ohrid@woodcraft.mk || 4.8 || 4567891234567 || Sara Vaneva || BOSS || admin || — || placed order || 2025-12-01 10:15:00 || credit card ****6750 || 0.0 || Excellent craftsmanship || 5.0 || 2025-12-03 18:00:00 || 002122025001 || 2024-12-04 09:10:00 || Military discount || Discount approved || 5.0 || 2024-11-30 23:59:59 || 98000.00 || Stable || Moderate growth || S.Vaneva || 2024-11-01 || 8000.00 || — || — || 450 || weekly || 52 || 2025-11-24 - 2025-11-30 || 0.5 || 2025-12-03 13:06:12 || 26150 || 2024-12-01 08:00:00 || 40 || NULL || 398 ||
     10|| 0022025000002 || Ivan Stojanov || ivan@gmail.com || st.Partizanska 10, Skopje 1000, Macedonia || 00200001 || Heart crochet || crochet-heart-red.jpg, crochet-heart-blue.jpg || Blue, Red, Yellow, Green || 150 || 10 || 0.2 || 20x20x15 || 2 || 0 || 3 || 002 || Fox Crochets || 2023-06-01 || st.Kej Makedonija 12, Ohrid 6000, Macedonia || ohrid@woodcraft.mk || 4.8 || 4567891234567 || Sara Vaneva || BOSS || admin || — || packaging || 2025-12-10 18:00:00 || PayPal account ******* || 0.0 || Beautiful handmade product || 5.0 || 2025-12-11 18:00:00 || — || — || — || — || — || 2024-11-30 23:59:59 || 98000.00 || Stable || Moderate growth || S.Vaneva || 2024-11-01 || 8000.00 || 2024-11-12 15:30:00 || Added new color || 450 || weekly || 52 || 2025-11-24 - 2025-11-30 || 0.0 || 2025-12-03 13:06:12 || 26150 || 2024-12-01 08:00:00 || 40 || NULL || 450 ||
     11|| 0012025000002 || Antoneta Mariovska || mariovskaantoneta@finki.ukim.mk || st.32 4, s.Cucer-Sandevo, Skopje, Macedonia || 00100001, 00200001 || Handmade wooden chair with oak wood, Heart crochet || chair.jpg, crochet-heart-red.jpg || Brown, Blue, Red || 850 || 50, 10 || 2.5, 0.2 || 30x20x10, 20x20x15 || 10, 2 || 50, 0 || 2 || 001,002 || WoodCraft Skopje & Fox Crochets || 2015-03-12; 2023-06-01 || st.Ilindenska 45, Skopje 1000, Macedonia; st.Kej Makedonija 12, Ohrid 6000, Macedonia || contact@woodcraft.mk; ohrid@woodcraft.mk || 4.6, 4.8 || 9876543210987; 4567891234567 || Antonio Trajkovski; Sara Vaneva || EMPLOYEE; BOSS || M.Petrovski; admin || 2019-09-01; — || packaging || 2025-12-12 16:30:00 || credit card ****4582 || 5.0 || Very satisfied || 5.0 || 2025-12-14 12:00:00 || 003122025001 || 2024-12-10 14:00:00 || Packaging question || Explained packaging process || 5.0 || 2024-11-30 23:59:59 || 223000.00 || Increasing || Stable growth & Moderate growth || M.Petrovski; S.Vaneva || 2024-11-01 || 20500.00 || 2024-11-10 09:00:00; 2024-11-12 15:30:00 || FROM aprox_production_time=14 TO aprox_production_time=10; Added new color || 75; 450 || hourly; weekly || 38; 52 || 2025-11-24 - 2025-11-30 || 0.0; 0.0 || 2025-12-01 09:56:30; 2025-12-03 13:06:12 || 64900.00 || 2024-12-01 08:00:00 || 92 || 750 || 850 ||
     12|| 0022025000003 || Ivan Stojanov || ivan@gmail.com || st.Partizanska 10, Skopje 1000, Macedonia || 00200002 || Decorative wall hanging made with beads || wall_hanging.jpg || Black and Gold || 199 || 100 || 0.75 || 40x40x1 || 14 || 0 || 1 || 002 || Fox Crochets || 2023-06-01 || st.Kej Makedonija 12, Ohrid 6000, Macedonia || ohrid@woodcraft.mk || 4.8 || 4567891234567 || Sara Vaneva || BOSS || admin || — || placed order || 2025-12-15 11:45:00 || credit card ****3281 || 2.0 || Wonderful decoration || 5.0 || 2025-12-20 15:00:00 || 004122025001 || 2024-12-16 10:30:00 || Shipping question || Tracking number provided || 5.0 || 2024-11-30 23:59:59 || 98000.00 || Stable || Moderate growth || S.Vaneva || 2024-11-01 || 8000.00 || — || — || 450 || weekly || 52 || 2025-11-24 - 2025-11-30 || 0.5 || 2025-12-03 13:06:12 || 26150.00 || 2024-12-01 08:00:00 || 40 || NULL || 195.02 ||
    1313
    1414==== Problems with the Denormalized Table