Normalization of Data Prepare the base tables, in third normal form, needed to produce the user view below.

Transcribed Image Text:

Problem 11: Normalization of Data USER VIEW Part Reorder Unit Ven Num Description QOH Point EOQ Cost Num Ven Name Ven Address Tel 132 Bolt 100 50 1000 1.50 987 ABC Co. 654 Elm St 555 5498 143 Screw 59 10 100 1.75 987 ABC Co. 654 Elm St 555 5498 760 Nut 80 20 500 2.00 742 XYZ Co. 510 Smit 555 8921 982 Nail 100 50 800 1.00 987 ABC Co. 654 Elm St 555 5498