Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me with that please DBS201 Exercise 5 Normalize User Views and Create a Final 3NF solution Good News Grocers This report is

image text in transcribed

image text in transcribed

Can you help me with that please

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 Aisle Number Price Unit of Measure Department Product Code 4081 4027 4108 0.35 0.90 1.99 lb Produce Produce Produce ea lb 331100 331105 332110 1.50 Butcher Butcher Butcher lb lb 5 5.00 411100 521101 866503 866504 Freezer ea ea ea Freezer 6 Freezer Freezer 1.00 5.00 5.00 Good News Grocers User View 2: Product Cost Report Supplier Product Cost Markup Price Dept Code 21-Very Veggie 4108-tomatoes, plum 4081 -bananas 4027-grapefruit 4851 - cele 331100-chicken wings 331105-lean ground beef 332110-boneless chicken breasts 411100-orange juice 521101-apple juice 866503-vanilla ice cream 1.89 0.20 0.45 32- Fab Fruits 32 - Fab Fruits 32- Fab Fruits 08-Meats R Us 08- Meats R 08- Meats R Us 10-Jerry's Juice 10-Jerry's Juice 45- Icey Creams 45-Icey Creams866504-chocolate ice cream 75% 100% 100% 300% 400% 100% 0.35 PR 2.00 0.50 0.60 2.50 0.25 0.25 5.00 400% 100% 1100% 5.00 FR 2.50 This report is used by the grocery store manager to determine the final his products selling price of

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions