= Normalization

== Denormalized form

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.

||= //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 =||
|| 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  ||
|| 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   || Placed Order || Credit Card || 0.0       || Excellent craftsmanship               || 5.0    || 002122025001 || 0.0 || 98000         || 8000           || Stable      ||
|| 0022025000002 || Ivan Stojanov      || ivan@gmail.com       || st.Partizanska 10, Skopje || 00200001          || Heart Crochet    || crochet-heart-red.jpg, crochet-heart-blue.jpg || Blue, Red, Yellow, Green                        || 150      || 3   || Fox Crochets                || 4.8          || Sara Vaneva        || Sara Vaneva || Packaging    || PayPal      || 0.0       || Beautiful handmade product            || 5.0    || —            || —                  || 98000         || 8000           || Stable      ||
|| 0012025000002 || Antoneta Mariovska || mariovskaantoneta@finki.ukim.mk || st.32 4, s.Cucer-Sandevo  || 00100001,00200001 || Wooden Chair, Heart Crochet || chair.jpg, crochet-heart-red.jpg              || Brown, Blue, Red               || 850      || 2   || WoodCraft Skopje & Fox Crochets || 4.0    || Antonio Trajkovski || Marko Petrovski || Packaging    || Credit Card || 0.05       || Very satisfied                        || 5.0    || 003122025001 || Packaging question || 223000        || 20500          || Increasing  ||
|| 0022025000003 || Ivan Stojanov      || ivan@gmail.com      || st.Partizanska 10, Skopje || 00200002          || Decorative Wall Hanging     || wall_hanging.jpg                     || Black & Gold            || 199      || 1   || Fox Crochets                    || 4.8          || Sara Vaneva        || Sara Vaneva     || Placed Order || Credit Card || 2%       || Wonderful decoration                  || 5.0    || 004122025001 || Shipping question  || 98000         || 8000           || Stable      ||