DBS201 Exercise 5 Normalize User Views and Create a Final 3NF solution Good News Grocers This report is used by the department managers to update the prices that are displayed in the grocery store for these products. User View 1 - Price Update List Department Product Aisle Unit of Price Number Measure Code 4081 4108 331100 0.35 0.90 1.99 lb ea lb Produce lb Butcher lb Butcher332110 ea ea ea ea Freezer Freezer Freezer 521101 866503 6 6 6 5.00 5.00 Good News Grocers User View 2: Product Cost Report Supplier Product Cost Markup Price Dept Code PR PR PR PR BU BU BU 4108-tomatoes.plum 1.99 0.35 21 -Very Veggie 32 Fab Fruits 32 Fab Fruits 32- Fab Fruits 08 - Meats R Us 08- Meats R Us 08-Meats R Us 10 Jerry's Juice 4108 tomatoes, plum 4081-bananas 0.20 0.45 1 00% 300% 100% 0.50 0.60 331100-chicken wings 331105-lean ground beef 32110-boneless chicken breasts-12 0 411100-oran 521101-apple juice 866503-vanilla ice cream 866504-chocolate ice cream 5.00 FR 45-Icey Creams 45-Icey Creams 100% This report is used by the grocery store manager to determine the final selling price his products