Attribute Types

When we design ER-Diagram there are several types of attributes that may be required to be dealt . Few of them are Listed below.
Simple or Atomic:-
These attributes can’t be sub-divided further . In other words , the atomic attributes hold single value and not composed of any other attributes.
Example:-
RegNo , Age, Date_Of_Birth , Dept_No , Sex etc.
Composite:-
The attributes that can be sub-dived into somemore attributes are called as composite attributes.
For example,
If u wish to store the address of an employee ,one choice is to name the attribute as address .However , an address is generally composed of House number , Cross ,Main ,Street name ,Area ,City ,State ,Country , PinCode , etc.
Composite Example
Address
HouseNo Cross Main StreetName Area City State Country PinCode
Similarly , Attribute name need not be atomic . It can have multiple Values or sub-divided.
Single valued , Multi-valued , stored ,derived , nullEntity sets, Key , Domain, composite key
Single Valued attribute.
Multi-Valued attribute.
Stored attribute.
Derived attribute.
Null .