Ingredient Purchase Invoice

Ingredient table must contain:

• Ingredient Stock

Based on the above case:

• Create normalization for Purchase Invoice (UNF, 1NF, 2NF, 3NF)

Please make some detail explanation for me to learn about normalization

Ingredient Purchase Invoice Date: Aug 11, 2018 Purchase ID Supplier ID Supplier Name Supplier Address Payment Type PCH001 SUP001 Samuel Budiman Mawar Street No 31580101 Cash Quantity No. Ingredient ID 1 IGR010 Ingredient Name Chocolate Vanilla Ingredient Brand Tom & Jerry's Dairy King 10 Purchase Price 20000 IDR 30000 IDR 20000 IDR Subtotal 200000 IDR 900000 IDR 1000000 IDR 2 IGR003 D lui ce momenteam in 30 3 IGR004 Milk Powder Nastle 50 4 IGR005 Cream Great Walls 10000 IDR 20 200000 IDR 5 IGR006 Tapioca Syrup Talenta 25000 IDR 20 500000 IDR 2800000 IDR Grand Total Nixon Lim Staff Purchasing