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

Transcribed Image Text:

Problem 12: Normalization of Data USER VIEW Part Num Reorder Unit Ven 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 1.55 750 RST Co. 3415 8th St 555 3421 1.45 742 XYZ Co. 510 Smit 555 8921 982 NAIL 100 50 800 1.00 987 ABC Co. 654 Elm St 555 5498 1.10 742 XYZ Co. 510 Smit 555 8921 1.00 549 LMN Co. 18 Oak St 555 9987