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