Problem:
The table below demonstrates an extract from tour operator’s data on travel agent bookings.
Required:
Question 1: The data in the table is subject to anomalies. Give illustrations of how deletion, insertion, and modification anomalies could occur on this table.
Question 2: Recognize the functional dependencies represented by data in table. Illustrate any assumptions you make about data.
Question 3: Using all intermediate steps. The functional dependencies identified, originate the third normal form of the data, showing all intermediate steps.
Question 4: Sketch an Entity-Relationship model for the data in the table. Show all entities, relationships, and attributes.