FDS
Consider a relation R(A,B,C,D,E) with the following dependencies:
{AB-> C, CD -> E, DE -> B}
List all candidate keys.
ANS=
To find the candidate keys for the given relation R(A, B, C, D, E) with the functional dependencies {AB->C, CD->E, DE->B},
-
Check {A}:
- {A+} = {A}
-
Check {B}:
- {B+} = {B}
-
Check {C}:
- {C+} = {C}
-
Check {D}:
- {D+} = {D}
-
Check {E}:
- {E+} = {E}
-
Check {AB}:
- {AB+} = {ABCE}
-
Check {AC}:
- {AC+} = {AC}
-
Check {AD}:
- {AD+} = {AD}
-
Check {AE}:
- {AE+} = {AE}
-
Check {BC}:
- {BC+} = {BC}
-
Check {BD}:
- {BD+} = {BD}
-
Check {BE}:
- {BE+} = {BE}
-
Check {CD}:
- {CD+} = {CDEB}
-
Check {CE}:
- {CE+} = {CE}
-
Check {DE}:
- {DE+} = {DEB}
- {AB} and {CD} are the candidate keys for the given relation R(A, B, C, D, E) with the provided functional dependencies.