598 views
2 votes
2 votes

If AD is the only candidate key for some relation R(A,B,C,D,E) then will CD → E be considered a partial dependency? 

2 Answers

Best answer
6 votes
6 votes

 

This is a snippet from Fundamentals of Database Systems by Navathe. Let us look at the paragraph.

 

It is talking about full functional dependency, which we can see that if we remove of any attribute $A$ from $X$ in the functional dependency $X\rightarrow Y$, the dependency will become invalid.

 

OUR QUESTION;-

 

 

If AD is the only candidate key for some relation R(A,B,C,D,E) then will CD → E be considered a partial dependency? 

Case 1:-

 

Remove $C$ from the functional dependency to check whether $D\rightarrow E$ is satisfying the functional dependency or not.

Since $AD$ is the only candidate key, $D$ cannot alone find $E.$

 

Case 2:-

 

Remove  $D$ from the functional dependency to check whether $C\rightarrow E$ is satisfying the functional dependency or not, and here also we cannot comment on this functional dependency.

 

Hence it is the case of full dependency, not partial dependency and we will not consider $CD\rightarrow E$ to be a partial dependency.

 

 

selected by
2 votes
2 votes
No,

The rule says partial dependencies are : prime attribute determined nonprime attribute.

here prime attributes are {A, D}, if A or D alone determined any other nonprime then it is partial dependencies.

in this case CD -> E, D is combined with C and determined E. So, CD becomes nonprime attributes.

CD →.E is nonprime → nonprime.

Related questions

1 votes
1 votes
2 answers
2
Na462 asked Jun 29, 2018
545 views
1 votes
1 votes
1 answer
3
Harikesh Kumar asked Dec 1, 2017
457 views
https://gateoverflow.in/?qa=blob&qa_blobid=11537552088967137608
1 votes
1 votes
2 answers
4
agoh asked May 10, 2017
1,092 views
Does any normal form impose the condition "every non-key should depend upon every key"?