Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with the following exercise: CECS 4202/09 Advanced Database Systems Final Project WI 2018 Deadline: Feb 18, 201* Name: Section: Question 1: Data
I need help with the following exercise:
CECS 4202/09 Advanced Database Systems Final Project WI 2018 Deadline: Feb 18, 201* 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 MWNumberSamplngDate +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 SamplingDate SamplingMethods State StreetAddress Transmissivity TypeofTreatment UTNumber ZIP In addition to the functional dependencies implied by the functional dependencies have been identified primary key, the following Contaminant AcceptableLevel FacilityID FacilityName Facility!D StreetAddress FacilityID-City FacilityID -State FacilityID-ZIP FacilityIDPhone FacilityIDContactPerson UTNumberFacilityID UTNumber DateofPermitissue UTNumberDrivingContaminant UTNumberInitialContaminantMass UTNumberTypeofTreatment UTNumberDepth Water UTNumber GroundwaterFlow Direction UTNumberHydraulicGradient UTNumber-AquiferThickness UTNumbeHydraulicConductivity UTNumber-Transmissivity UTNumberMethodsused UTNumber +MWNumberMWDiameter UTNumber MWNumberMwdepth UTNumberMWNumber MWCoordinates UTNumber MWNumber SamplingDate-Performedby UTNumber + MWNumber + SamplingDate Analytica!POC 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 foreign key relationshipsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started