Normalise relation to third normal form

Question

Problem:

The table above lists customer/car-hire data.

Required:

Question 1: The data in the table is subject to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.

Question 2: Identify the functional dependencies represented by the data in the table. State any assumptions you make about the data.

Question 3: By using the data above, normalise the relation to Third Normal Form.  Show any intermediate relations and explain each step in the normalisation process.  Underline the keys in each relation.

Question 4:  Draw an Entity-Relationship model for the data in the above table. Show all the entities, relationships, and attributes.