Question: i need tables in my sql Good News Grocers User View 1 - Price Update List Department Price Product Code Aisle Number Unit of Measure

i need tables in my sql
Good News Grocers User View 1 - Price Update List Department Price Product Code Aisle Number Unit of Measure Ib Produce Produce Produce 4081 4027 4108 1 1 1 0.35 0.90 1.99 ea lb Butcher Butcher Butcher 331100 331105 332110 5 5 5 1.50 2.40 5.0 lb Ib Ib ea ea Freezer Freezer Freezer Freezer 411100 521101 866503 866504 6 6 6 6 1.00 1.00 5.00 5.00 ea ea This report is used by the department managers to update the prices that are displayed in the grocery store for these products. Good News Grocers User View 2: Product Cost Report Supplier Product Cost Markup Price 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 10 - Jerry's Juice 45 - Icey Creams 45 - Icey Creams 4108 - tomatoes, plum 4081-bananas 4027 - grapefruit 4851 - celery 331100 - chicken wings 331105 - lean ground beef 332110 - boneless chicken breasts 411100 - orange juice 521101 - apple juice 866503 - Vanilla ice cream 866504 - chocolate ice cream 1.89 0.20 0.45 1.00 0.50 0.60 2.50 0.25 0.25 2.50 2.50 5% 75% 100% 100% 300% 400% 100% 400% 400% 100% 100% 1.99 0.35 0.90 2.00 1.50 2.40 5.00 1.00 1.00 5.00 5.00 Dept Code PR PR PR PR BU BU BU FR FR FR FR This report is used by the grocery store manager to determine the final selling price of his products. Merage the View 1 and View 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
