Simple and Composite Attributes
For Complete YouTube Video: Click Here
In this class, we will understand Simple and Composite Attributes.
We have already discussed the definition of attributes.
Table of Contents
Simple and Composite Attributes
An attribute is a property that describes an entity.
There are different types of attributes in this class; we discuss Simple and Composite Attributes.
Simple Attributes
If we cannot divide an attribute further is called a simple attribute.
The image below is the employee entity type with name, address, sex, and date of birth.
In the above image, if we consider the sex attribute, this cannot be further divided.
Similarly, we cannot divide the DoB attribute.
Composite attributes
The composite attributes are just opposite to the definition of simple attributes.
If we can divide an attribute into smaller subparts, they are called composite attributes.
If we consider the name and address attributes, we can divide them into subparts.
We can divide the name attribute into First Name, Middle Initial, and Last Name.
Similarly, we can divide the address attribute into Street name, Area name, District, City, State, and Country.
We can further divide the street name into door number and street name.
ER-Diagram Representation
How can we represent the simple and composite attributes in the ER-Diagram?
The image below shows the representation.