Changes between Version 3 and Version 4 of Normalization
- Timestamp:
- 07/14/26 07:14:27 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v3 v4 5 5 Below 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. 6 6 7 ||= //order_num =||= //client_name =||= //client_email =||= //delivery_address =||= //product_code(s) =||= //product _images =||= //product_colors =||= //product_price =||= //order_quantity =||= //store_ID =||= //store_name =||= //store_rating =||= //employee =||= //store_owner =||= //order_status =||= //payment =||= //discount =||= //review-comment =||= //order_rating=||= //request=||= //request_problem=||= //request_problem =||= //report_profit =||= //monthly_profit =||= //product_price =||= //sales_trend =||7 ||= //order_num =||= //client_name =||= //client_email =||= //delivery_address =||= //product_code(s) =||= //product(s) =||= //product_images =||= //product_colors =||= //product_price =||= //order_quantity =||= //store_ID =||= //store_name =||= //store_rating =||= //employee =||= //store_owner =||= //order_status =||= //payment =||= //discount =||= //review-comment =||= //order_rating=||= //request=||= //request_problem=||= //request_problem =||= //report_profit =||= //monthly_profit =||= //product_price =||= //sales_trend =|| 8 8 || 0012025000001 || Marija Kostova || marija@yahoo.com || st.Turisticka 5, Bitola || 00100001 || Handmade Wooden Chair || chair.jpg || Brown || 700 || 1 || WoodCraft Skopje || 4.6 || Antonio Trajkovski || Marko Petrovski || Delivered || Cash || 0.04 || Great quality, slightly late delivery || 4.5 || 001112025001 || Late delivery || 125000 || 12500 || Increasing || 9 9 || 0022025000001 || Ivan Stojanov || ivan@gmail.com || st.Partizanska 10, Skopje || 00200002 || Decorative Wall Hanging || wall_hanging.jpg || White & Pink, Black & Gold, Orange-Green-Purple || 199 || 2 || Fox Crochets || 4.8 || Sara Vaneva || Sara Vaneva || Placed Order || Credit Card || 0.0 || Excellent craftsmanship || 5.0 || 002122025001 || 0.0 || 98000 || 8000 || Stable ||
