0
9.9kviews
Types of Attributes with example.

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.

Please log in to add an answer.

Continue reading...

The best way to discover useful content is by searching it.

Search