What is aggregation in DBMS?Explain in simple words.

Editorial / Best Answer

Bapineedu Bollempalli  

  • Member Since Sep-2011 | Sep 18th, 2011


A concept which is used to model a relationship between a collection of entities and relationships. It is used when we need to express a relationship among relationships. Aggregation - a feature of the entity relationship model that allows a relationship set to participate in another relationship set. This is indicated on an ER diagram by drawing a dashed box around the aggregation.

Showing Answers 1 - 42 of 42 Answers

A concept which is used to model a relationship between a collection of entities and relationships. It is used when we need to express a relationship among relationships.

Aggregation - a feature of the entity relationship model that allows a relationship set to participate in another relationship set. This is indicated on an ER diagram by drawing a dashed box around the aggregation.

  Was this answer useful?  Yes

kumar

  • Oct 1st, 2011
 

collection of entities...

  Was this answer useful?  Yes

joyce shelton

  • Apr 8th, 2013
 

Summarized data

  Was this answer useful?  Yes

Anuj

  • Nov 10th, 2013
 

The Process through which one can treat the relationship as higher level entities is known as aggregation.

  Was this answer useful?  Yes

IRFAN AHMED SHARFI

  • Jun 6th, 2014
 

Aggregation is an abstraction through which relationship are treated as higher level entity..

  Was this answer useful?  Yes

Sergey Alentyev

  • Mar 29th, 2015
 

Aggregation means assembling component parts together. So, it is not just about relationship. For example, I had separate Customer table that had address_id column linked to Address table. For some reason (probably performance) I decided to replace foreign key link address_id by real address values like street address, city, zip code, etc. This is an aggregation. Not necessary a de-normalization.

  Was this answer useful?  Yes

Radha

  • Jun 2nd, 2015
 

When a relationship between two entities is considered as a single entity and again this single entity has a relationship with another entity, this is called an aggregation

  Was this answer useful?  Yes

avadh don

  • Oct 13th, 2015
 

Aggregation is the process of compiling information on an object, thereby abstracting a higher level object

  Was this answer useful?  Yes

anupam jha

  • Oct 31st, 2016
 

Aggregation is a process when relation between two entities is treated as a single entity. Here the relation between center and course, is acting as an entity in relation with visitor.

  Was this answer useful?  Yes

Mohammed Bhaijaan

  • Nov 3rd, 2016
 

Aggregration is a process when relation between two entity is treated as a single entity. eg. two enties center, course. the relation between Center and Course, is acting as an Entity in relation with Visitor.

  Was this answer useful?  Yes

Sumayya

  • Jan 9th, 2017
 

Aggregation can be used when we need to express a relationship among relationships.

  Was this answer useful?  Yes

Vishnu

  • Jul 16th, 2017
 

To get aggregate values of a column. For example sum(quantities) sold of a product in a day.

  Was this answer useful?  Yes

Ajmal Hussain

  • Nov 25th, 2017
 

Aggregation of processes, when two entities are treated as a single entities then it is known as aggregation.
Here center and courses are acting as a single entitys and then enquires with visitors relationship does not accept ternary relationships, So it is improved by aggregation.
So it is combined two entities and treat as a single entity.

  Was this answer useful?  Yes

Nitin Rathod

  • Apr 14th, 2018
 

Aggregation is an abstraction through which relationships are treated as a higher level entities
Ex :- There exites a ternary relationship teaches between a teacher, department and subject entites, than relationship will be represented as.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions