Explain aggregation with example.

This answer is restricted. Please login to view the answer of this question.

Login Now

In aggregation, the relation between two entities is treated as a single entity. In aggregation, relationship with its corresponding entities is aggregated into a higher level entity.

For Example, Employee working for a project may require some machinery. So, REQUIRE relationship is needed between relationship WORKS_FOR and entity MACHINERY. Using aggregation, WORKS_FOR relationship with its entities EMPLOYEE and PROJECT is aggregated into single entity and relationship REQUIRE is created between aggregated entity and MACHINERY.

Representing aggregation via schema –

To represent aggregation, create a schema containing:

  1. primary key of the aggregated relationship
  2. primary key of the associated entity set
  3. descriptive attribute, if exists.
If you found any type of error on the answer then please mention on the comment or report an answer or submit your new answer.
Leave your Answer:

Click here to submit your answer.

  Loading . . .