8. An agency called Instant Cover supplies part-time/temporary staff to hotels in Scotland. Figure 12.4 lists the time spent by agency staff working at various hotels. The national insurance number (NIN) is unique for every member of staff. Use Figure 12.4 to answer questions (a) and (b) a. This table is susceptible to update anomalies. Provide examples of insertion, deletion and update anomalies. b. Normalize this table to third normal form. State any assumptions NIN ContractNo Hours eName 1135 C1024 1057C1024 1068 C1025 1135 |C1025 hNo hLoc H25 East Killbride 16 24 28 15 Smith J. Hocine D. H25 East Killbride White T. Smith J. H4 Glasgow H4Glasgow Figure 12.4 For question 8, by A. Watt