Example & Tutorial understanding programming in easy ways.

What is prime and non attribute in table attribute?

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 →