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
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 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
Login/Signup to comment