769 views
1 votes
1 votes

I am little bit confused about the CLOSURE OF A SET-OF-FUNCTIONAL-DEPENDENCIES .

If I am given a set of Functional dependencies F, then how the F+ is defined ?

  • Is it defined as the union of the closures of LHS of each of FD within F 
  • Or is it calculated as set of all valid functional dependencies (including the additional functional dependencies - which are calculated from inference rules)

I am following Navathe 6th edition and here they have given procedure to calculate the closure of LHS of FD within a set of FD's, however, I did not find any procedure to find out the closure of the set of FDs.

Thank You

Please log in or register to answer this question.

Related questions

1 votes
1 votes
1 answer
1
Shweta Nair asked Oct 24, 2017
576 views
Consider the relation R(A,B,C) and functional dependencies F={A->B, B->C} then what are the number of functional dependencies in $F^{+}$ ?
4 votes
4 votes
2 answers
3
prathams asked Dec 26, 2015
1,827 views
Given the following functional dependencies$\left\{X \rightarrow W, X \rightarrow Y, Y \rightarrow Z, Z \rightarrow PQ\right\}$Consider the $FD$ set implied using above $...
6 votes
6 votes
5 answers
4