Composite Attribute in DBMS

Composite Attribute in DBMS


In this article, we will learn about Composite Attribute in DBMS.

Sometimes an attribute entity may be further broken into smaller attributes and all attributes can be generalized into a common attribute.


Composite Attributes in DBMS

Composite Attribute definition

Composite attributes are nothing but the attribute can be divided  further into more than one attribute i.e an attribute can have further sub-attributes

Example for Composite attribute

address attribute can have further  detailed into sub-attributes like Street, pin code, state, country, etc  and here” address attribute is a composite  attribute.

Representation of composite attribute 

It is represented using an oval which further consists of some other ovals attached to it.