Composite Attribute in DBMS

Composite Attributes

A composite attribute in DBMS is an attribute that is made up of multiple sub-attributes or component attributes. These component attributes are related to each other and together they form a composite attribute.
Composite Attribute in DBMS

Composite Attribute in DBMS

On this page, 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 Attribute in DBMS img

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.

Prime Course Trailer

Related Banners

Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others

Checkout list of all the video courses in PrepInsta Prime Subscription

Checkout list of all the video courses in PrepInsta Prime Subscription