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.

hNo hLoc H25 East Killbride NIN ContractNo Hours eName 1135 C1024 1057 C1024 1068 C1025 1135 C1025 16 24 28 15 Smith J Hocine D. H25 East Killbride White T Smith J H4 Glasgow H4 Glasgow Figure 12.4 For question 8, by A. Watt