retagged by
321 views
0 votes
0 votes

Consider a relation $R$$\left ( A, B,C,D, E  \right  )$ with the following $FD$ set $F$:

 $A\rightarrow BC$
 $CD\rightarrow E$
 $B\rightarrow D$
 $E\rightarrow A$

The canonical cover of the above $FD$ set is:

  1.   $A\rightarrow BC$, $C\rightarrow E$ , $B\rightarrow D$ , $E\rightarrow A$
  2.   $A\rightarrow BC$ , $CD\rightarrow E$ , $B\rightarrow D$ , $E\rightarrow A$
  3.   $A\rightarrow B$ , $CD\rightarrow E$ , $BC\rightarrow D$ , $E\rightarrow A$
  4.   $A\rightarrow BC$ , $B\rightarrow E$ , $B\rightarrow D$ , $E\rightarrow A$
retagged by

1 Answer

Best answer
1 votes
1 votes
No extra attributes and no FD is redundant in the given FD set, hence its canonical cover is given FD set itself .
selected by
Answer:

Related questions

0 votes
0 votes
1 answer
3
Bikram asked Feb 9, 2017
263 views
Consider these relations :$R = ABCDE$$A\rightarrow BC$$B\rightarrow E$$D\rightarrow E$What is the candidate key for the above relations?CAABBDAD
1 votes
1 votes
1 answer
4