Attributes

Types of Attributes

Simple Attribute - Atomic Values.

An attribute that cannot be divided further.

Example: ssn

Composite Attribute

Made up of more than one simple attribute.

Example: firstname + mi + lastname

Derived Attribute

Calculated from existing attributes.

Age: Derived from DOB

Multivalued Attribute

An attribute that can have multiple values for a single entity (e.g., PhoneNumbers for a person).

src: https://www.tutorialspoint.com/dbms/er_diagram_representation.htm

Student: Entity
Name: Composite Attribute
Student ID: Simple Attribute
Age: Derived Attribute
PhoneNo: MultiValued Attribute
(The Student can have more than one phone number)