(a) Prepare the base tables, in third normal form, needed to produce

Problem 8: Normalization of Data

Problem 8: Normalization of Data USER VIEW Part# 132 143 760 982 Description Bolt Screw Nut Nail QOH 100 59 80 100 Reorder Point 50 10 20 50 EOQ I OOO 100 500 800 Unit Cost I .50 1.75 2.00 I .00 Ven # 742 Ven Name ABC co. ABC co. XYZ co. ABC co. Ven Address 654 Elm St 654 Elm St 510 Smit 654 Elm St Tel 555 5498 555 5498 555 8921 555 5498