Copyright

Suppose we have relation R(A,B,C,D,E), with some set of FD's, and we wish to project those FD's...

Question:

Suppose we have relation R(A,B,C,D,E), with some set of FD's, and we wish to project those FD's onto relation S(A,B,C,D). Give the FD's that hold in S if the FD's for R are: {eq}AB \rightarrow C, BC \rightarrow D, CD \rightarrow E, DE \rightarrow A {/eq}, and {eq}AE \rightarrow B {/eq}.

Functional dependency in Database:

A functional dependency is when one attribute of table is defined as the other attributes. Four Type of functional dependency: Multivalued,trivial, non-trival,transitive.

Answer and Explanation:

Become a Study.com member to unlock this answer! Create your account

View this answer

S{A,B,C,D} So ignore E tupple

The relation is in S{A,B,C,D}

{eq}AB \rightarrow C, BC \rightarrow D, {/eq},

AND Relation DE->A, AE->B

D->...

See full answer below.


Learn more about this topic:

Loading...
What are Databases? - Examples & Types

from

Chapter 11 / Lesson 12
298K

Related to this Question

Explore our homework questions and answers library