14.8The table below lists customercar hire data. Each customer may hire cars from various outlets throughout Glasgow. A car is registered at a particular outlet and can be hired out to a customer on a given date. clientlDcFNameCLName joblD pickupDateTime driverlD dFName dL 1001 25/07 00.10.00 1456 1102 29/07/00.10.00 1456 1203 30 07 00.11.00 1344 1334 2/08/00.1300 1455 208 00.13.00 1676 25/08 00.10.00 1344 C034 Anne CO34Anne CO34Anne C089 Mark C019John CO39 Karen Watt ane ane oim Karen Steven 1 Stoie Road, Paisl 111 Storrie R 111 Storrie 120 Lady Lane, Paisley Watt ones Black Smith a15 Fields Brown13 Renfrew Road, Paisl Worth 34 High Street, Pai I666 1957 oim ones (a)The data in the table is susceptible to update anomalies. Provide examples of hovw insertion, deletion, and modification anomalies could occur on this table. (b) Identify the functional dependencies represented by the data shown in the table. State any assumptions you make about the data. (c)Using the functional dependencies identified in part (b), describe and illustrate the process of normalization by converting Table I to Third Normal Form BNF) relations. Identify the primary and foreign keys in your 3NF relations