 Welcome back MechanicalEI! Did you know that Enhanced Entity Relationship or EER model was developed to precisely reflect constraints in complex databases such as in engineering design and manufacturing? This makes us wonder, what is an Extended Entity Relationship Model? Before we jump in, check out the previous part of this series to learn about what an Entity Relationship Model is. Now, an Extended Entity Relationship or EER model, as the name suggests, is a high-level data model that incorporates the extensions to the original EER model. They have the following three extensions. First, they include subclasses and superclasses, which are the entities that belong to generalization and specialization respectively. Put simply, superclasses is an entity type that relates to one or more subclasses where subclasses is a subgroup of entities with unique attributes. Second is union or category type extension. It represents a single superclass or subclass relationship with more than one superclass. For example, while booking a car with a loan, owner is a subset of the union of three superclasses, the company, bank and the person. The third and final extension that an EER model offers is that of aggregation. An EER diagram is not capable of representing the relationship between an entity and a relationship, which may be required in some scenarios. In those cases, a relationship with its corresponding entities is aggregated into a higher-level entity. For example, employee working for a project may require some machinery. So, the required relationship is needed between relationship works for and entity machinery. Using aggregation works for relationship with its entities, employee and project is aggregated into a single entity and relationship require is created between aggregated entity and machinery. Hence, we first saw what an extended entity relationship model is and then went on to see what its three extensions, including aggregation, are. So, like, subscribe and comment with your feedback to help us make better videos. Thanks for watching. Also, thanks a lot for those constructive comments. You helped the channel grow. So, here are the top mechanical years of our last videos. In the next episode of Mechanical EI, find out what a relational model is.