1. Draw a dependency diagram to show the functional dependencies in the relation 2. Decompose the relation into a set of 3NF relations 3. Draw a relational schema for your 3NF relations and show the referential integrity constraints 4. Create an ERD that represents your 3NF relations

Prod Name Purchase date Qty sold Prod priceInv No -5565 endor ID Vendoi Prod code S12345 v Date 19.50 85 190 Esky Soft 12/7/2016 17/7/2016 112 18/9/2016 106 18/9/2016 103 60 sfa ooler gle inder AK2347 15/9/2016 10 -5570 C To