Please login

Prime

Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video
Prime

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

Key Attributes in DBMS

Key Attributes in DBMS

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

  • Attributes define what type of data is stored in a database table
  • For example student table stores the details of Student name, roll no, marks, attendance, etc all these details corresponding to the properties or attributes of the student table.

Key attribute

  • The key attribute is capable of uniquely identifying an entity from an entity set
  • Database table key attribute helps in uniquely recognize and access records.
Key Attributes in DBMS

Example for Key attribute

For example, a student table consists of details of roll no, age, name, address .among these attributes student roll no helps to easily  identify the   of the record corresponding to a particular student

Representation

The key attribute is represented using an oval with the attribute name underlined inside the oval.

Learn more about DBMS here on this page.