Composite Attribute
- When 2 or more than 2 simple attributes are combined to make an attribute then that attribute is called a Composite attribute.
- The composite attribute is made up of multiple attributes. After combining these attributes, the composed attributes are formed.
- Complex attributes are used where data is complex and needs to be stored in a complex structure.
Example
- Here if we look at the below example, address is the attribute derived from the 3 simple attributes i.e. City, State, and Street.
- To get the value of the address attribute, we have first to know those city, state, and street attributes.
- This type of attribute is known as a composite attribute.
Attributes in DBMS
Attributes are properties or characteristics of an entity. Attributes are used to describe the entity. The attribute is nothing but a piece of data that gives more information about the entity. Attributes are used to distinguish one entity from the other entity. Attributes help to categorize the entity and the entity can be easily retrieved and manipulate the entity. Attributes can help the database to be more structural and hierarchical. An entity with no attribute is of no use in the database.
Contact Us