Good News Grocers User View 2: Product Cost Report Supplier Product Cost Markup Price Dept Code 21 - Very Veggie 4108-tomatoes, plum 1.89 5% 1.99 PR 32 - Fab Fruits 4081 - bananas 0.20 75% 0.35 PR 32 - Fab Fruits 4027-grapefruit 0.45 100% 0.90 PR 32-Fab Fruits 4851 - celery 1.00 100% 2.00 PR 08 - Meats R Us 331100 - chicken wings 0.50 300% 1.50 BU 08 - Meats R Us 331105 - lean ground beef 0.60 400% 2.40 BU 08 - Meats R Us 332110 - boneless chicken breasts 2.50 100% 5.00 BU 10 - Jerry's Juice 411100-orange juice 0.25 400% 1.00 FR 10 - Jerry's Juice 521101 - apple juice 0.25 400% 1.00 FR 45 - Icey Creams 866503- vanilla ice cream 2.50 100% 5.00 FR 45 - Icey Creams 866504 - chocolate ice cream 2.50 100% 5.00 FR This report is used by the grocery store manager to determine the final selling price of his products. Represent this form in UNF. In creating your representation you should note that Super Electronics wish to treat the client name, address and phone as simple attributes. Convert your UNF to first normal form (1NF) and then continue the normalisation to fourth normal form (4NF). At each normal form show the appropriate dependencies for that normal form, if there are none write "No Dependencies" Do not add new attributes during the normalisation. Clearly write the relations in each step from the unormalised form (UNF) to the fourth normal form (4NF). Clearly, indicate primary keys on all relations from 1NF onwards. Specifically find the answer to the following question. While answering these questions define all the dependencies properly. For example if you are talking about partial dependency then explain what is a partial dependency