Changes between Version 9 and Version 10 of Normalization

Timestamp:

07/14/26 07:22:40 (12 days ago)

Author:

235018

Comment:

--

Normalization

@@ -11 +11 @@
 || 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   || 001,002 || WoodCraft Skopje & Fox Crochets || 4.0    || Antonio Trajkovski || Marko Petrovski || Packaging    || Credit Card || 0.05       || Very satisfied                        || 5.0    || 003122025001 || Packaging question || 223000        || 20500          || 750 || Increasing  ||
 || 0022025000003 || Ivan Stojanov      || ivan@gmail.com      || st.Partizanska 10, Skopje || 00200002          || Decorative Wall Hanging     || wall_hanging.jpg                     || Black & Gold            || 199      || 1   || 002 || Fox Crochets                    || 4.8          || Sara Vaneva        || Sara Vaneva     || Placed Order || Credit Card || 0.02       || Wonderful decoration                  || 5.0    || 004122025001 || Shipping question  || 98000         || 8000           || 350 || Stable      ||
+
+
+==== Problems with the Denormalized Table
+
+This table contains several issues:
+
+*  Multiple products may appear in one order.
+*  A product may have multiple colors.
+*  A product may have multiple images.
+*  Client information repeats for every order.
+*  Store information repeats for every product sold.
+*  Employee and boss information repeats.
+*  Reports and profits repeat for every order.
+*  There are repeating groups, making updates difficult.
+*  Insertion, deletion, and update anomalies may occur.
+
+Because of these problems, the table is not in First Normal Form.