Problem:
The table above lists customer/car-hire data.
Required:
problem 1: The data in the table is subject to update anomalies. Provide exs of how insertion, deletion, and modification anomalies could occur on this table.
problem 2: Identify the functional dependencies represented by the data in the table. State any assumptions you make about the data.
problem 3: By using the data above, normalise the relation to Third Normal Form. Show any intermediate relations and describe each step in the normalisation process. Underline the keys in each relation.
problem 4: Draw an Entity-Relationship model for the data in the above table. Show all the entities, relationships, and attributes.