Please Complete the Inventory table and Vendor able.

Prepare the base tables, in third normal form, needed to produce the user view in the table for Problem 11. PROBLEM I1: NORMALIZATION OF DATA USER VIEW Reorder Unt Ven Ven Part Num Description QOH Point EOQ CostNum Ven NameAddressTel 132 143 760 982 Bolt Screw Nut Nail 100 59 80 100 50 1000 10 100 20 500 50 800 1.50 987 ABC Co. 654 Elm St 555 5498 1.75 987 ABC Co. 654 Elm St 555 5498 2.00 742 XYZ Co. 510 Smit 555 8921 1.00 987 ABC Co.654 Elm St 555 5498 Complete the Inventory and Vendor Tables with the following . Part Number . Description .QOH Reorder Point .EOO . Unit Cost . Vendor Number . Vendor Name .Vendor Address Vendor Telephone The primary key should be identified in the first column (furthest left) of the Inventory Table & Vendor Table. The foreign key should be identified in the last column (furthest right), if applicable Complete the rest of the table in the order provided above (in bullet points). Please copy and paste the answers from the list above Inventory Table endor Table