Question

What is enhanced ER Model? Explain extended ER features: Specialization, Generalization and Aggregation with your clear definitions/ideas/differences in your own words and give at least one appropriate example for each one of them.

Answer 1

Enhanced ER model is basically the extension to the old ER models only. This is helpful for the cases when we are unable to represent with the help of traditional ER models then EER can help.

It can be used for displaying the following.

1. Sub Class and Super Class
2. Specialization and Generalization
3. Union or Category
4. Aggregation

Specialization

It is the process in which one entity is subdivided into more than one items and it is dependent on the characteristics of the entities in which it is getting divided.

In this, there is the specialization in which employees can be converted into either Developer or Tester.

Generalization

It is opposite to specialization, in this more than one entity is combined together to form one single entity.

In this, whether the animal is lion, tiger or element they all are generalized as animals.

Aggregation

It is helpful for letting us know about the relationship between the whole attribute and its components.

In this case, the course and college are collectively acting as they both are together in relation to a student.

That was a nice question to answer
Friend, If you have any doubts in understanding do let me know in the comment section. I will be happy to help you further.
Please like it if you think effort deserves like.
Thanks