Prime attribute:
Prime attribute is the attribute which is the part of the candidate key.
Non-prime attribute:
Non -prime attribute is the attribute which is not the part of the candidate key.
Example:
Table have four attribute : A,B,C,D
candidate key : AB
then,
prime attribute is: A and B
non-prime attribute is: C and D
Read More →