Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Normalize this table in 3NF and create a MySQL ERD model for it. Supplier Markup Price DeptCode 1.89 5% $ 1.99 PR 21 - Very

Normalize this table in 3NF and create a MySQL ERD model for it.

image text in transcribed

Supplier Markup Price DeptCode 1.89 5% $ 1.99 PR 21 - Very Veggie 32 - Fab Fruits 32 - Fab Fruits 32- Fab Fruits 0.20 0.45 75% $ 100% $ 100% $ 0.35 PR 0.90 PR 2.00 PR 1.00 08 - Meats R Us 0.50 300% $ 1.50 IBU Table 2 Product Cost 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 08 - Meats R Us 0.60 400% $ 2.40 BU 08 - Meats R Us 2.50 100% $ 5.00 IBU 10 - Jerry's Juice $ 0.25 400% $ 1.00 FR 10 - Jerry's Juice 0.25 400% $ 1.00 FR 45 - Icey Creams 2.50 100% $ 5.00 FR 45 - Icey Creams 866504 - chocolate ice cream $ 2.50 100% $ 5.00 FR

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

Recommended Textbook for

The Manga Guide To Databases

Authors: Mana Takahashi, Shoko Azuma, Co Ltd Trend

1st Edition

1593271905, 978-1593271909

More Books

Students also viewed these Databases questions

Question

What do you think Kates reaction will be?

Answered: 1 week ago