Part 1. [15 points]. Complete exercise E.4.5 [E.4.5.a, E.4.5.b, E.4.5.c, E.4.5.d, E.4.5.e, E.4.5.f, E.4.5.g]. Picture for reference is attached below.
Part 2. [15 points]. Complete exercise E.4.6 [E.4.6.a, E.4.6.b, E.4.6.c, E.4.6.d, E.4.6.e, E.4.6.f, E.4.6.g]. Picture for reference is attached below
.
E4.1 Create an example of a relation (containing sev- E4.3 Using the relation created in exercise E4.1, eral records) that is prone to update anomalies. describe an example that illustrates the deletion E4,2 Using the relation created in exercise E4.1, anomaly. describe an example that illustrates the insertion E4.4 Using the relation created in exercise E4.1, anomaly. describe an example that illustrates the modification anomaly. E4.5 Consider the following relation with sample data. - Each airline operating at KX airpor E4.5d Depict full key functional dependencial the Airport KLX Table. limes assigned to it. - Each day (Date), this table records the Number of E4.5f Show the result of normalizing the firpes KLX Table to 3NF. KLX Table to 3NF. an examply. E4.6 Consider the following relation with sample data. - The DEPARTMENT OF TRANSPORTATION E4.6b Using the DOT PROJECT Table, describe (DOT) Project Table captures the data about projects example that illustrates the deletion anongialit and their length (in miles). E4.6c Using the DOT PROJECT Table, descatile - Each project has a unique Project ID and Project _EA.6c Using the DOT PROJECT Table, descilit E4.6a Using the DOT PROJECT Table, describe an example that illustrates the insertion describe how the anomalies show anomaly. E4.1 Create an example of a relation (containing sev- E4.3 Using the relation created in exercise E4.1, eral records) that is prone to update anomalies. describe an example that illustrates the deletion E4,2 Using the relation created in exercise E4.1, anomaly. describe an example that illustrates the insertion E4.4 Using the relation created in exercise E4.1, anomaly. describe an example that illustrates the modification anomaly. E4.5 Consider the following relation with sample data. - Each airline operating at KX airpor E4.5d Depict full key functional dependencial the Airport KLX Table. limes assigned to it. - Each day (Date), this table records the Number of E4.5f Show the result of normalizing the firpes KLX Table to 3NF. KLX Table to 3NF. an examply. E4.6 Consider the following relation with sample data. - The DEPARTMENT OF TRANSPORTATION E4.6b Using the DOT PROJECT Table, describe (DOT) Project Table captures the data about projects example that illustrates the deletion anongialit and their length (in miles). E4.6c Using the DOT PROJECT Table, descatile - Each project has a unique Project ID and Project _EA.6c Using the DOT PROJECT Table, descilit E4.6a Using the DOT PROJECT Table, describe an example that illustrates the insertion describe how the anomalies show anomaly
