The table shown in Figure 1 lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff. \begin{tabular}{1111111111[1]} \hline NIN & contractNo & hours & eName & hno & hLoc \hline 1135 & C1024 & 16 & Smith J & H25 & East Kilbride 1057 & C1024 & 24 & Hocine D & H25 & East Kilbride 1068 & 01025 & 28 & White T & H4 & Glasgow 1135 & C1025 & 15 & Smith J & H4 & Glasgow \hline \end{tabular) Figure 1: Instant Cover's contracts 1. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and modification update anomalies. 2. List the non-trivial functional dependencies in the table shown in Figure 1. State any assumptions you make about the data shown in this table. 3. Modify the table to be in Boyce-Codd normal form. 4. Display the data in Figure 1 using the tables in Boyce-Codd normal form. CS.VS. 1123