Types of attributes in DBMS, derived, single valued, simple, multivalued, stored, composite

 Types of Attributes:-

Simple Attribute:- 

The attributes that cannot be further divided in to smaller part an represents the basic meaning is called a simple attributes. Eg:- Age attributes of person entity represent a simple attribute.

Composite Attribute:- 

Attribute that can be further divided into smaller unit & each individual unit contains a specific meaning. Eg:- Name attribute of an employ can be sub divided.

Multivalued Attribute:- 

Attribute that have more than one values for a particular entity is called a multivalued attributes. Eg:- Phone no. for a person entity is a multivalued entity.

Stored Attributes:-

 Attribute that are directly stored attribute. Eg:- Date of joining attributes of employ entity.

 Single valued attribute:-

 Attribute having a single value for a particular entity. Eg:- Age is an single valued attribute of a student entity.

Derived Attribute:- 

Attributes are not stored directly but  can be derived from stored attributes are called derived attributes.