Prime and Non Prime Attributes

Prime Attributes also referred as Key attributes. Similarly Non Prime attributes also called as Non Key attributes.

Prime or Key Attributes:

Attributes of the relation which exist in at least one of the possible candidate keys, are called prime or key attributes.

Non Prime or Non Key Attributes:

Attributes of the relation which does not exist in any of the possible candidate keys of the relation, such attributes are called non prime or non key attributes.

Note:

In order to distinguish whether an attribute of the relation is prime or non prime, we should always find all the possible candidate keys of the give relation.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s