What is Composite Attribute in DBMS?
FREE
A database component, such as a field or table, is an attribute. It is of many types like simple, single-valued, multi-valued, composite, complex, and many more. The attribute that cannot be divided into more parts is known as simple attributes. The attributes that divide themselves into more sub-parts are known as composite attributes. Composite attribute divides itself into multiple simple attributes. Let us learn about composite attributes in DBMS more through this article.
Example
Student Roll Number, employee ID, Account balance, Salary, Account number, and Aadhar number are an example of simple attributes as they cannot be further divided into sub-parts. Name and address are an example of complex attributes as they get further divided into sub-parts. Name can be divided into sub-parts First name, Middle name, and Last name. An address can be divided into house number, street, locality, city, state, and pin code.
Transform Your Career
Choose from our industry-leading programs designed for career success
Modern Software and AI Engineering Program
Master full-stack development with AI integration
+1000 moreModern Data Science and ML with specialisation in AI
Advanced data science techniques with AI specialization
+1000 moreAdvanced AIML with Specialisation in Agentic AI
Deep dive into AIML with focus on Agentic systems
+1000 moreDevOps, Cloud & AI Platform Engineering
Build and manage AI-powered cloud infrastructure
+1000 moreAI Engineering Advanced Certification by IIT-Roorkee
Premier AI engineering certification from IIT-Roorkee
Representation of Composite Attribute
We represent a composite attribute in DBMS using an oval shape attached to oval shapes that represent simple attributes.
Methods for Mapping
The relation names are represented by an entity set of ER diagrams. The attribute of an ER Diagram represents the name of a column.
Let us see an example of mapping an ER Diagram with a composite attribute.
We will draw the ER Diagram for the following relation:
| CustomerID | Name | Street | City | State | Pincode |
|---|
In the above relation, we can see that the attribute CustomerID and Name are simple attributes. The address is a composite attribute whose components are street, city, state, and pin code.
Learn more:
Scaler Placement Report and Statistics
Scaler learners achieved 2.5x salary growth with average post-Scaler CTC reaching ₹23L.
Conclusion
- Composite attributes in DBMS are those attributes that can be further divided into more simple attributes.
- Student Roll Number, employee ID, Account balance, Salary, Account number, and Aadhar number are an example of simple attributes.
- Name and Address are an example of complex attributes.
- Name can be divided into simple attributes like first, middle, and last name.
- Composite attribute in DBMS is represented by an oval shape attached to more oval shapes denoting simple attributes.
- The names of the relation are represented by an entity set, and the name of the column is represented by the attribute in an ER Diagram.
Google
Amazon
Microsoft
Flipkart
Adobe1200+ more