Composite Attribute in DBMS
Composite AttributesA 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 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.
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