Q3. Read the scenario given below and answer the following questions and also normalize the given data up to the 3rd Normal form? . 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). NIN Contract No Hours eName hNo hloc 1135 C1024 16 Smith J. 1125 Fast Killbride 1057 C1024 24 llocine D. 1125 East Killbride 1068 C1025 28 White T. 114 Glasgow 1135 C1025 15 Smith J. Glasgow Figure 12.4 For question 8, by A. Watt. H4 1. This table is susceptible to update anomalies. Provide examples of insertion, deletion and update anomalies. 2. Normalize this table to third normal form. State any assumptions