search
Log In
1 vote
152 views
Consider a relation R(ABCD) with functional dependency F:{ AD → B, AB → C }. Is AB → C partial or total dependency?
in Databases 152 views
1
it is a transitive dependency Since here candidate keys AD.

AD->C , Here C is a non-prime attribute determined by combination of prime attribute and Non-prime attribute and here it is a transitive dependecny.
0
Yes, it is a transitive dependency.
0

https://gateoverflow.in/492/gate2008-69

its transitive dependency

1
0
No partial dependency, no transitive dependency

will be in 3NF
0
ma'am see my comment,it is right?
0

@Lakshman Patel RJIT Bro check out the link posted by @Soumya29

0
Navathe says

from key itself remove an attribute and still if there dependency exists then it will be partial dependency

Here that is not the case

So, no partial dependency

Now A->B->C

here if B is not key or not part of key and then onlytransitive dependency exists

But here AB->C

B is part of key

So, can we not say no transitive dependency too?
0

@srestha ma'am

According to a similar question in ACE material, AB is considered to be a part of key.

Please log in or register to answer this question.

Related questions

4 votes
4 answers
1
270 views
Consider a relation $R\left ( A,B,C,D,E \right )$ and functional dependencies are $F=\left \{ AC\rightarrow B,C\rightarrow D,A\rightarrow E,C\rightarrow B \right \}$ Relation $R$ is decomposed into $R_{1}\left ( A,B,C \right )$ and $R_{2}\left ( C,D \right )$ Then Is it a lossless decomposition? I am getting doubt, how it can be not lossless decomposition?
asked Apr 28, 2019 in Databases srestha 270 views
0 votes
0 answers
3
67 views
Can someone explain the paragraph marked based on relation $r$ given in Figure 7.2? Reference: Database System Concepts by Silberschatz, Korth, Sudarshan 4th Edition. ​​​​​
asked Jan 5, 2019 in Databases zeeshanmohnavi 67 views
0 votes
0 answers
4
237 views
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 ... 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
asked Jun 22, 2018 in Databases Harsh Kumar 237 views
...