Third normal form. Thanks

Name: Section: Question 1: Data Normalization (60 points) A local environmental regulatory agency collects data on leaking underground storage tanks. The agency currently maintains the data in the following table: Table: SAMPLING DATA Primary Key: UTNumber+MWNumber+ SamplingDate+Contaminant Attributes: AcceptableLevel AnalyticalPOC AquiferThickness City Concentration ContactPerson Contaminant DateofPermitIssue Depthto Water DrivingContaminant FacilityID FacilityName GroundwaterFlowDirection HydraulisConductivity HydraulicGradient InitialContaminantMass Methodused MWNumber MWCoordinates MWDepth MWDiameter MWNumber Performdeby Phone Sampling Date SamplingMethods StreetAddress Transmissivity TypeofTreatment UTNumber ZIP In addition to the functional dependencies implied by the primary key, the following functional dependencies have been identified. Contaminant AcceptableLevel FacilityIDFacilityName FacilityID -StreetAddress FacilitylD ->City FacilitylID State FacilityID - > ZIP FacilityID-Phone FacilityID- ContactPerson UTNumber Facility!) UTNumber DateofPermitIssue UTNumber >DrivingContaminant UTNumber-InitialContaminant Mass UTNumber TypeofTreatment UTNumber DepthWater UTNumber GroundwaterFlow Direction UTNumber -HydraulicGradient UTNumber >AquiferThickness UTNumber HydraulicConductivity UTNumber Transmissivity UTNumber >Methodsused UT Number + MWNumber MWDiameter UTNumber +MWNumber Mwdepth UTNumber+MWNumber- MWCoordinates UTNumber + MWNumber + SamplingDate Perfomedby UTNumber + MWNumber+ SamplingDate >AnalyticalPOC Preserve the functional dependencies and decompose the table into a set of tables in the third normal form. Ensure that it is a lossless-join decomposition. Give each table an appropriate name. Specify the attributes in the tables and identify the primary keys Specify the forcign key relationships