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

An attribute is a property that describes an entity.

There are different types of attributes in this class; we discuss Simple and Composite 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.

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.

How can we represent the simple and composite attributes in the ER-Diagram?

The image below shows the representation.