Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribedimage text in transcribedimage text in transcribed

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 relationships

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice

Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis

1st Edition

3662570564, 978-3662570562

More Books

Students also viewed these Databases questions