Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 2Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started