Non Prime Attributes in DBMS

Non Prime Attributes in DBMS

 

In this article, we will learn about Non Prime Attributes in DBMS.

  • Attributes of the relation which does not exist in any of the possible candidate keys of the relation, such attributes are called non prime attributes.
  • Non prime attributes also called as Non Key attributes.
Non Prime Attribute in DBMS

 

Examples :

Consider the following table:

IDNAMEAGECITYPHONE_ NO
66Alex21Noida9535653232
67Luke22Delhi8353355366
68Haley19Noida7323598665
69Luke21Mumbai8656864365

 

  • [ID] : Every individual will have a unique ID so it is a prime attribute.
  • [NAME] : Two different persons might have same name, so it is non prime attribute
  • [AGE] : Two different persons might have same age, so it is non prime attribute
  • [CITY] : Two different persons might be living in the same city, so it is non prime attribute
  • [PHONE_NO] : No two persons will have same phone number, so it is not a non prime attribute
Learn more about DBMS here in this page.