534 views
2 votes
2 votes
Consider relation R(ABCD) and FD = {AB->CD,C->A,D->B}. Which of the following is false?
(A) C->A is a partial dependency
(B) C->A is a transitive dependency
(C) D->B is a partial dependency
(D) All of these

1 Answer

2 votes
2 votes
D) All of these

Partial dependency means X->Y  where X is proper subset of a candidate key ie. X is a prime attribute and Y is a non prime attribute.

In the given Question,  A, B, C, D all are prime attributes so partial dependency doesn't exist.

and transitive dependency is when A->B  and B->C  then A->C is a transitive dependency , which also doesn't exist
edited by

Related questions

4 votes
4 votes
1 answer
3
naveen bhatt asked Dec 7, 2018
1,430 views
Consider the relation R(A,B,C,D,E) with the functional dependencies :A → B, B → C, C → A, D → E, and E → DThe Maximum possible super-keys of R is ______________...
1 votes
1 votes
0 answers
4