b. The table shown below lists the time spent by agency staff working at two hotels....

 

Transcribed Image Text:

b. The table shown below lists the time spent by agency staff working at two hotels. The Emp ID is unique for each employee. Emp ID Contract No 1177567 MIT1009 1256788 MIT10010 2246769 MIT10011 2254678 MIT10012 3758956 MIT10013 4237890 MIT10014 Hours Assigned Hotel contact No HotelNo HotelLocation PerWeek 17 20 30 30 25 36 045566790 056678954 045566790 056678954 045566790 056678954 H12 H40 H12 H40 H12 H40 Ringwood Melbourne CBD Ringwood Melbourne CBD Ringwood Melbourne CBD Provide examples of insertion, deletion, and modification anomalies that may occur in the above table. Propose a suitable solution to overcome these issues. b. The table shown below lists the time spent by agency staff working at two hotels. The Emp ID is unique for each employee. Emp ID Contract No 1177567 MIT1009 1256788 MIT10010 2246769 MIT10011 2254678 MIT10012 3758956 MIT10013 4237890 MIT10014 Hours Assigned Hotel contact No HotelNo HotelLocation PerWeek 17 20 30 30 25 36 045566790 056678954 045566790 056678954 045566790 056678954 H12 H40 H12 H40 H12 H40 Ringwood Melbourne CBD Ringwood Melbourne CBD Ringwood Melbourne CBD Provide examples of insertion, deletion, and modification anomalies that may occur in the above table. Propose a suitable solution to overcome these issues.