Consider the following relation with sample data E4.6: Department of Transportation (DOT) Project Table ProjectID ProjectName CountyID CountyName ProjectManagerID ProjectManagerName ProjectMilesWithinCounty 1 1 1 2 3 3 4 5 Road x Road x Road x Road Y Bridge A Bridge A Tunnel Q Road w 1 2 3 3 1 2 2 4 Wilson Ottawa Davis Davis Wilson Ottawa Ottawa Pony M1 M1 M1 M2 M3 M3 M1 M4 Bob Bob Bob Sue Lee Lee Bob Bob 10.00 17.00 12.00 23.00 0.50 0.30 2.00 23.00 E4.6a Using the DOT PROJECT Table, describe an example that illustrates the insertion anomaly. E4.6b Using the DOT PROJECT Table, describe an example that illustrates the deletion anomaly. E4.6c Using the DOT PROJECT Table, describe an example that illustrates the modification anomaly. E4.6d Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the DOT PROJECT table. E4.6e Show the result of normalizing the DOT PROJECT Table to 2NF E4.6f Show the result of normalizing the DOT PROJECT Table to 3NF E4.6g Using the set of tables resulting from E4.6f, describe how the anomalies shown in E4.6a, E4.6b, and E4.6c are eliminated. E4.7: SHIPMENTS Table ShipmentID 111 111 222 333 333 444 555 ShipmentDate 1-Jan 1-Jan 2-Jan 3-Jan 3-Jan 3-Jan 3-Jan TruckID T-111 T-111 T-222 T-333 T-333 T-222 T-111 TruckType Semi-Trailer Semi-Trailer Van Truck Semi-Trailer Semi-Trailer Van Truck Semi-Trailer ProductID A B C D A C B ProductType Tire Battery SparkPlug Wipers Tire SparkPlug Battery Quantity 180 120 10,000 5000 200 25,000 180 E4.7a Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the SHIPMENTS Table. E4.7b Show the result of normalizing the SHIPMENTS Table to 2NF E4.7c Show the result of normalizing the SHIPMENTS Table to 3NF