Hey guys, would anyone be wiling to give me some help on normalization? I am taking my first computer class and I have not been taught it and it is not in our book, yet we still have a project due on it. Any help would be greatly appreciate. Here it is below:
Following an un-normalized database for an order processing system. Normalize this database into 1st, 2nd and 3rd normal form.
Customer order processing( customer ID, customer company name, customer address, customer contact name, customer contact title, customer city, customer region, customer postal code, customer country, customer phone ( order ID, order date, required date, shipped date, order freight, shipper ID, shipper company name (Product ID, order detail quantity, order detail discount (Product ID, product name, quantity per unit, product unit price, units in stock, units on order, reorder level, discontinued (Supplier ID, supplier company name, supplier address, supplier city, supplier region, supplier postal code, supplier country, supplier phone)))))
I really have no experience and I am not looking for a way out or for someone to do it for me, but some help would be fantastic! Thanks