Access Millions of academic & study documents

5 Identify the set of functional dependences in the relation instan

Content type
User Generated
Showing Page:
1/2
5. Identify the set of functional dependences in the relation
instance CAR shown next. Does this constitute the minimal
cover for the set of functional dependencies presents in
CAR? If it is not a minimal cover, derive a minimal cover.
CAR
Solution
functional dependencies:let R be a relation schema and
X,Y be non empty sets of attributes in R.so we can say an
instance r of R satisfies functional dependecy X-> y1 if it
satisfies fallowing conditions.
if t1.X= t2.X then t1.Y=t2.Y
from the given example the functional dependencies in car
are :
1) cylinders->fee
2)origin->tax
minimal cover means get rid of the redundant attributes in
left side in functional dependencies
but the functional dependencies that we obtain are minimal
cover functional depencies only.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/2

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
5. Identify the set of functional dependences in the relation instance CAR shown next. Does this constitute the minimal cover for the set of functional dependencies presents in CAR? If it is not a minimal cover, derive a minimal cover. CAR Solution functional dependencies:let R be a relation schema and X,Y be non empty sets of attributes in R.so we can say an instance r of R satisfies functional dependecy X -> y1 if it satisfies fallowing conditions. if t1.X= t2.X then t1.Y=t2.Y from the given example the functional dependencies in car are : 1) cylinders->fee 2)origin->tax minimal cover mean ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents