The Gateway to Computer Science Excellence
+1 vote
111 views
Consider a relation R(ABCD) with functional dependency F:{ AD → B, AB → C }. Is AB → C partial or total dependency?
in Databases by Active (2.1k points) | 111 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

0 votes
0 answers
2
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,741 questions
57,251 answers
198,056 comments
104,684 users