CECS 4202/09 Database Final Project June 11, 2018 SP 2018 Name Section Question

Question

CECS 4202/09 Database Final Project June 11, 2018 SP 2018 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 DateofPermitlssue Depthto Water DrivingContaminant FacilityID FacilityName GroundwaterFlowDirectio HydraulisConductivity HydraulicGradient InitialContaminantMass Methodused MWNumber MWDepth MWDiameter MWNumber

Explanation / Answer

Sampling_Master(UTNumber,MWNumber,SamplingDate,Performedby,AnalyticalPOC)

               Primary key : UTNumber,MWNumber,SamplingDate

Sampling_Details

(UTNumber, FacilityID,DateOfPermitIssue,DrivingContaminat,InitialContaminatMass,

TypeofTreatment, DepthWater,GroundwaterFlowDirection,HydraulicGradient,AquiferThickness,

HydraulicConductivity,Transmissivity,Methodsused)

              Primary key: UTNumber

               Foreign key: UTNumber from Sampling_Master , FacilityID from Facillity_Details

Facility_Details (FacilityID,FacilityName,StreetAddress, City,State,ZIP,Phone,ContactPerson)

             Primary key: FacilityID

MachineDimen_Sampling(UTNumber,MWNumber,MWDiameter,Mwdepth,MWCoordinates)

              Primary key: UTNumber,MWNumber

              Foreign_Key : UTNumber from Sampling_master

Contaminant_Verification(Contaminant,AcceptableLevel,Concentration, UTNumber)

              Primary key : Contaminant

          Foreign_Key : UTNumber from Sampling_master

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.