Hello again. This is another table that I would like to see in 3rd Normal Form (

Question

Hello again. This is another table that I would like to see in 3rd Normal Form (3NF) along with the dependencies. Thanks in advance.

Table 2 Cost Supplier Markup DeptCode Product 4108 - tomatoes, Price 5%) $ 21 - Very Veggie 32 Fab Fruits 32 Fab Fruits 32 Fab Fruits 1.99 PR 0.35 PR 0.90 PR 2.00 PR 1.50 BU 1.89 4081- bananas 4027 - grapefruit$ 4851 -celery 331100- chicken 0.20 0.45 1.00 75%) $ 100%) $ 100% $ 300%) $ 400%) $ 100%) $ 400901 $ 400%) $ 100%) $ 08- Meats R Us 0.50 331105- lean ground beef 332110-boneless chicken breasts 411100-orange uice 2.40 BU 5.00 BU 1.00 FR 1.00 FR 5.00 FR 08- Meats R Us 0.60 08- Meats R Us 2.50 10 - Jerry's Juice 10 - Jerry's Juice 521101- apple juice $ 45-Icey Creams 0.25 0.25 866503-vanilla ice 2.50 cream 866504- chocolate 45 - Icey Creams 2.50 100%) $ 5.00 FR ice cream

Explanation / Answer

Please find my answer:

Table- Supplier

SupplierCode

Supplier

21

Very Veggie

32

Fab fruits

Table- ProductInfo

DeptCode

ProductCode

SupplierCode

PR

4108

21

PR

4081

32

Please rate my answer if it helped you!!

SupplierCode

Supplier

21

Very Veggie

32

Fab fruits

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.