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. |
0 comments:
Post a Comment