Different Types of Attributes in DBMS

Related Articles

Every object in the real world with self-existence is considered to be an entity in the world of computers. Like a car, any person, any book, painting, news, construction Anything available in this world can be considered as an entity.

Characteristics or specifications of each entity are known as attributes of that entity. Attributes are physical or virtual characteristics of an entity.

There are mainly 8 types of features, let’s discuss them one by one in detail.

Feature types in DBMS

1. Complex features

You can divide these attributes that may contain more than one section like last name, first name, middle name, last name. You can fill complex attributes in subsections but always show as a single attribute. Like you can enter your name in three parts but the display will be integrated. These parentheses “()” are used to represent complex attributes.

2. Simple features

The same traits that can no longer be divided as each person’s age.

3. Single-value properties

The same traits whose values ​​always remain the same as each person’s name.

4. Multi-valued features

These attributes whose values ​​have more than one record such as a person’s name are singularly valued but his / her degree number can be more than one. As under graduation and after degree. These parentheses “” are used to represent multi-valued attributes.

5. Derived attributes

The same traits whose value can be deduced from other traits as from the date of birth we can deduce a person’s age.

6. Stored features

Those attributes whose value remains constant are known as stored attributes. Derived attributes are derived from stored attributes.

7. Complex features

It is a combination of the Multivalued and Composite features. These types of attributes have many sub-clauses in their values. Like any person’s degree you can dive at the end of a master’s degree. These degrees are also divided into additional details such as the name of the degree, the institution, the year of transition, etc.

8. Key Features

The same features whose value is unique to that entity. Such as the registration number of each student or the chassis number of each vehicle, etc. These types of key attributes are used to create different types of keys in relational data models.



Please enter your comment!
Please enter your name here

Popular Articles