edited by
2,640 views
2 votes
2 votes

For which of the following set of functions dependencies does the relation $R(A, B, C, D)$ has $AB, CD$ as closed sets?

  1. $A \rightarrow B, B \rightarrow A, C \rightarrow D$
  2. $A \rightarrow B, B \rightarrow C, C \rightarrow D, D \rightarrow A$
  3. $A \rightarrow B, B \rightarrow A, C \rightarrow A, D \rightarrow A$
  4. $A \rightarrow B, B \rightarrow A, C \rightarrow D, D \rightarrow C$

For which of the following set of functional dependencies does the relation R(A,B,C,D) has AB,CD as closed sets

edited by

2 Answers

3 votes
3 votes

Answer is option (B)

AB, CD are closed sets imply, does AB, CD cover all the attributes of R (attribute closure)
 

In option (A), 

AB closure is : { A B }
CD closure is : { C D }

In option (B), 

AB closure is : { A B C D }
CD closure is : { A B C D }

 

In option (C), 

AB closure is : { A B }
CD closure is : { A B C D }

 

In option (D), 

AB closure is : { A B }
CD closure is : { C D }

 

Thus, answer is option (B)

1 votes
1 votes
answer should be D)

set of attributes are closed under functional dependencies iff closure of attribute set is set itself.

(A,B)+ = {A,B}

(C,D)+ = {C,D}

and inside closed set , if  C ->D then D ->C should also need to satisfy.

Only D satisfies

example :to say  { a,b,c,d } is closed set.

{a,b,c,d}+ = {a,b,c,d}

let X , Y be any subsets of {a,b,c,d}

if X -> Y then Y -> X should present  (directly or indirectly which we can infer from given functional dependencies.
edited by

Related questions

0 votes
0 votes
1 answer
3
radha gogia asked Aug 16, 2015
13,676 views
R is not in 3NF R is in 3NF but not in BCNF R is in BCNF but not in 4NF R is in 4NF How to approach this ques ?
3 votes
3 votes
3 answers
4