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

Question

b. The table shown below lists the time spent by agency staff working at two hotels. The ID is unique for each employee Emp Emp IDConrc NoHoursAssigned Hotel contact NoHolNo Hotellocatiorn 1177567 MIT1009 1256788 MIT10010 2246769MIT10011 2254678 MIT10012 3758956MIT10013 4237890 MIT10014 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.

Explanation / Answer

Insertion will be costlier if we have to insert the employee of one of the two hotels because we have to write the hotel details (hotel name, location and contact number) again and again.

Deletion and Modification anomalies are quite similar . Suppose if we have to update or delete a hotel contact number or location then we have to update it in every entry which belongs to that particular hotel.

Ex - Update Contact number of hotel H12 to 045566780

Now we have to update every entry of H12

Solution -

Create two tables

Table 1 - Hotel Table

This table will have hotel name, hotel contact number and hotel location as columns or attributes

Table 2 - Employee

This table will have emplyee ID , Contract number, Hours assigned per week, Hotel Name

Now suppose we have to update hotel details then we can just update it in the hotel table and we don't have to make any change in employee table and there is no need to access employee table entries.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.