I need to answer number two but am having trouble normalizing the table. Please refer to the picture for the question.

2. Below is a sample of a table that shows a list of materials and suppliers for a furniture company. Before they build their database, they want tot make sure their logical design is flawless. They have asked you to ensure their design is in 3NF. Here are some key facts: a. Each material item has one or more suppliers. Each supplier may supply one or more items or no items at all. b. The unit price for a material item can vary from one vendor to another C. The terms code for the supplier uniquely identifies the terms of the sale (e.g. code 2 means 10 percent net 30 days). The terms for a supplier are the same for all material items ordered from that supplier each Attribute Name Sample Value Material ID 3792 Material Name Hinges 3" locking Unit of Measure Standard Cost $5.00 Vendor ID V300 Vendor Name Apex Hardware Unit Price $4.75 Terms Code 1 Terms COD Copyright 2016, by Pearson Education, Inc. 2. Below is a sample of a table that shows a list of materials and suppliers for a furniture company. Before they build their database, they want tot make sure their logical design is flawless. They have asked you to ensure their design is in 3NF. Here are some key facts: a. Each material item has one or more suppliers. Each supplier may supply one or more items or no items at all. b. The unit price for a material item can vary from one vendor to another C. The terms code for the supplier uniquely identifies the terms of the sale (e.g. code 2 means 10 percent net 30 days). The terms for a supplier are the same for all material items ordered from that supplier each Attribute Name Sample Value Material ID 3792 Material Name Hinges 3" locking Unit of Measure Standard Cost $5.00 Vendor ID V300 Vendor Name Apex Hardware Unit Price $4.75 Terms Code 1 Terms COD Copyright 2016, by Pearson Education, Inc