Attributes
An attribute is a single-valued property of either an entity-type
or a relationship-type. An attribute is a characteristic. Attributes are the descriptive properties which are owned by each entity.
An attribute is represented by an Ellipse in E-R diagram.
Types of Attributes
|
Description
|
Simple attribute
|
Simple attributes can't
be divided any further. For example, a student's contact number. It is also
called an atomic value.
|
Composite attribute
|
It is possible to break
down composite attribute. For example, a student's full name may be further
divided into first name, second name, and last name.
|
Derived attribute
|
This type of attribute
does not include in the physical database. However, their values are derived
from other attributes present in the database. For example, age should not be
stored directly. Instead, it should be derived from the DOB of that employee.
|
Multivalued attribute
|
Multivalued attributes
can have more than one values. For example, a student can have more than one
mobile number, email address, etc.
|
No comments:
Post a Comment