# 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.

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

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->...