Types of Attributes with example.

770views

written 2.6 years ago by

sagarkolekar ★ 11k

• modified 2.6 years ago

Attribute - It can be defined as set of all properties possessed by an entity or entity set.

Types of attributes are:

enter image description here

1] Simple Attributes - It is composed of single component with individual existence. simple attribute can not be further sub divided.

example, for entity employee age, salary can be simple attribute.

enter image description here

2] Composite attribute - An attribute composed of multiples components with independent existence is called as composite attribute.

enter image description here

3] Single value and multi-valued - An attribute having atomic value for a entity is called as single valued attribute.

enter image description here

every student have one id only. An attribute having many value, for an entity is called multi-valued attribute.

enter image description here

An employee may have multiple mobile numbers.

4] Stored and derived attribute -

sorted attribute - A simple attribute stored in database is called as stored attribute.

Derived attribute - A value of attribute which can be derived from related stored attribute is called derived attribute.

enter image description here

Null attribute - It takes null values for entities that does not have value for it.

ADD COMMENT EDIT