3) Local Farms are visited and a number of insect samples are taken from different fields. The number of each insect species (just Springtail and Beetle for now) in each sample is recorded. A version of the data is shown in the unnormalized table below. Note: A Visit to a farm could span multiple days and fields. FarmID . FarmName +1 Field . Date Visit . SampleID . Insect + Count . 1 HighGate F2 12-Mar-11 14 3 Beetle 1 HighGate F2 09-Feb-11 14 2 Beetle 1 HighGate F1 09-Feb-11 14 1 Beetle 1 HighGate F1 18-Mar-11 15 1 Springtail 1 HighGate F2 09-Feb-11 14 3 Springtail 1 HighGate F2 09-Feb-11 14 2 Springtail 1 HighGate F1 09-Feb-11 14 1 Springtail 1 High-Gate F1 18-Mar-11 15 1 Beetle 2 Greyton F2 09-Feb-11 16 1 Beetle 2 Greyton F1 09-Feb-11 16 2 Beetle ANJOU WU AAN 2 Greyton F1 09-Feb-11 16 2 Springtail 2 Greyton F2 09-Feb-11 16 1 Springtail W a) What are some of the updating problems that could occur with the above table? b) Which of the following functional dependencies hold for the insect data? (Yes/No) FarmID - FarmName . . . FarmID - Visit Visit - Date Date - Visit . . Visit - FarmID . . SampleID - Field (SampleID, Visit) - Field (SampleID, Insect) - Count (Visit, SampleID, Insect) - Count c) Apply the use the normalization rules to decompose the table into a set of tables in third normal form