Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman

13th Edition

0134773659, 978-0134773650

More Books

Students also viewed these Databases questions