Question: need solution with Entity Relationship Diagram, I do not need table answer. Please answer the same question with Entity Relationship Diagram(ERD) Using MySQL Workbench Data
need solution with Entity Relationship Diagram, I do not need table answer. Please answer the same question with Entity Relationship Diagram(ERD)


Using MySQL Workbench Data Modeler, create three (3) models from the tables below. Show Table 1 in 3rd Normal Form. Show Table 2 in 3rd Normal Form. Merge the 3rd Normal Forms of Table 1 and Tabie 2 into a single 3rd Normal Form model. Note that you only can model table and column names and data types. The data shown is for your reference to determine functional, partial, and transitive dependencies sr rea m Table 1 DepartmentProductCode Produce Produce Produce AisleNumber Price UnitofMeasure 4081 4027 4108 0.35 lb 0.90 ea 1.99 lb 1 Butcher Butcher Butcher 331100 331105 332110 1.50 llb 5 S2.40 b 5.00 b Freezer Freezer Freezer Freezer 4111001 61 5211016S 1.00 lea 866503S5.00 lea 866504 00 le ProductCost DeptCode Butcher Butcher 331105 332110 2.40 lb 5.00 ib Freezer Freezer Freezer Freezer 411100 521101 866503 1.00 ea 1.00 ea 5.00 ea 5.00 lea Table 2 Cost Supplier 21-Very Veggie 32 - Fab Fruits4081 bananas 0.20 32 Fab Fruits 08 Meats R Us 08- Meats R Us Product MarkupPrice DeptCode 4108-tomatoes plum 1.89 5%) $ 1.99 PR 0.35 PR 0.90 PR 2.00 PR 32-Fab Fruits 4027-grapefruit $ 4851-celery 331100- chicken wings 331105 lean ground beef 332110 -boneless 0.45 1.00 0.50 100%) $ 100%) $ 300%) $ 400%) $ 100%) $ 400%) $ 400%) s 1.50 BU 2.40 BU 5.00 BU 1.00 FR 1.00 FR 5.00 FR 0.60 o8 - Meats R Us chicken breasts 10-Jerry's Juice 10-Jerry's Juice 521101 - apple juice$ 45 Icey Creams 2.50 411100-orange uice 0:25 0.25 866503- vanilla ice cream 866504 chocolate ce cream 2.50 45 Icey Creams 2.50 100%) $ 5.00 FR
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
