Changes between Version 15 and Version 16 of Normalization
- Timestamp:
- 07/14/26 07:54:15 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v15 v16 56 56 || 3 || st.Ilindenska 20, 1000 Skopje || 57 57 58 == STORE58 ==== STORE 59 59 60 60 ||=// store_ID =||=// store_name =||=// store_rating =|| … … 63 63 64 64 65 == PRODUCT65 ==== PRODUCT 66 66 67 67 ||=// product_code =||=// description =||=// price =||=// weight =||=// delivery_cost =|| … … 71 71 72 72 73 == PRODUCT COLORS73 ==== PRODUCT COLORS 74 74 75 75 ||=// product_code =||=// description =||=// price =||=// weight =||=// delivery_cost =|| … … 78 78 || 00200002 || Decorative wall hanging made with beads || 199 || 0.75 || 0 || 79 79 80 == PRODUCT IMAGES80 ==== PRODUCT IMAGES 81 81 82 82 ||=// product_code =||=// image =|| … … 87 87 88 88 89 == ORDER89 ==== ORDER 90 90 91 91 ||=// order_num =||=// clien_ID =||=// status =||=// payment =||=// discount =|| … … 97 97 98 98 99 == ORDER PRODUCTS99 ==== ORDER PRODUCTS 100 100 101 101 || order_num || product_code || quantity || … … 108 108 109 109 110 == REVIEW110 ==== REVIEW 111 111 112 112 ||=// order_num =||=// rating =||=// comment =|| … … 118 118 119 119 120 == REQUEST120 ==== REQUEST 121 121 122 122 ||=// request_num =||=// client_ID =||=// problem =|| … … 127 127 128 128 129 == REPORT129 ==== REPORT 130 130 131 131 ||=// store_ID =||=// date =||=// overall_profit =||=// monthly_profit =||=// sales_trend =|| … … 134 134 135 135 136 === =Explanataion: UNF -> 1NF136 === Explanataion: UNF -> 1NF 137 137 138 138 The denormalized table violated First Normal Form because several attributes stored multiple values in a single cell. Examples include product colors, product images, multiple products in one order, and multiple stores associated with an order. These repeating groups made the data difficult to search, update, and maintain.
