Good News Grocers
User View 1 - Price Update List
Department Product
Code Aisle
Number Price Unit of Measure
Produce 4081 1 0.35 lb
Produce 4027 1 0.90 ea
Produce 4108 1 1.99 lb
Butcher 331100 5 1.50 lb
Butcher 331105 5 2.40 lb
Butcher 332110 5 5.00 lb
Freezer 411100 6 1.00 ea
Freezer 521101 6 1.00 ea
Freezer 866503 6 5.00 ea
Freezer 866504 6 5.00 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 Dept
Code
21 - Very Veggie 4108 - tomatoes, plum 1.89 5% 1.99 PR
32 - Fab Fruits 4081 - bananas 0.20 75% 0.35 PR
32 - Fab Fruits 4027 - grapefruit 0.45 100% 0.90 PR
32 - Fab Fruits 4851 - celery 1.00 100% 2.00 PR
08 - Meats R Us 331100 - chicken wings 0.50 300% 1.50 BU
08 - Meats R Us 331105 - lean ground beef 0.60 400% 2.40 BU
08 - Meats R Us 332110 - boneless chicken breasts 2.50 100% 5.00 BU
10 - Jerry's Juice 411100 - orange juice 0.25 400% 1.00 FR
10 - Jerry's Juice 521101 - apple juice 0.25 400% 1.00 FR
45 - Icey Creams 866503 - vanilla ice cream 2.50 100% 5.00 FR
45 - Icey Creams 866504 - chocolate ice cream 2.50 100% 5.00 FR
This report is used by the grocery store manager to determine the final selling price of his products.
Based on the two reports and design a database for Good News Grocers and make sure that the tables in your database are normalized to the 3rd Normal form.