Consider a relation R(A,B,C,D,E) and the only FDs,
These are the only 3 FDs. I want to know if the above relation is in 2NF or not.
According to the definition of 2NF, a relation to be in 2NF, it should be in 1NF and it should not have partial dependency.
But I'm not getting the partial dependency concept.
Somewhere it's written that when a proper subset of a key determines a non-prime attribute then it is partial dependency.
Somewhere it's written that when a prime attribute which is not a key determines a non-prime attribute then it is partial dependency.
Because of these 2 different definitions I'm getting confused.