Please login

Prime

Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video
Prime

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

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.