- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Extended Entity-Relationship (EE-R) Model
EER is a high-level data model that incorporates the extensions to the original ER model. Enhanced ERD are high level models that represent the requirements and complexities of complex database.
In addition to ER model concepts EE-R includes −
- Subclasses and Super classes.
- Specialization and Generalization.
- Category or union type.
These concepts are used to create EE-R diagrams.
Subclasses and Super class
Super class is an entity that can be divided into further subtype.
For example − consider Shape super class.
Super class shape has sub groups: Triangle, Square and Circle.
Sub classes are the group of entities with some unique attributes.Sub class inherits the properties and attributes from super class.
Specialization and Generalization
Generalization is a process of generalizing an entity which contains generalized attributes or properties of generalized entities.
It is a Bottom up process i.e. consider we have 3 sub entities Car, Truck and Motorcycle. Now these three entities can be generalized into one super class named as Vehicle.
Specialization is a process of identifying subsets of an entity that share some different characteristic. It is a top down approach in which one entity is broken down into low level entity.
In above example Vehicle entity can be a Car, Truck or Motorcycle.
Category or Union
Relationship of one super or sub class with more than one super class.
Owner is the subset of two super class: Vehicle and House.
Represents relationship between a whole object and its component.
Consider a ternary relationship Works_On between Employee, Branch and Manager. Now the best way to model this situation is to use aggregation, So, the relationship-set, Works_On is a higher level entity-set. Such an entity-set is treated in the same manner as any other entity-set. We can create a binary relationship, Manager, between Works_On and Manager to represent who manages what tasks.
- What is an Entity relationship model in DBMS?
- Entity-Relationship Diagram
- Entity Relationship Participation in Database
- What is Entity-Relationship Modeling?
- Importance of Entity-Relationship diagram in database design
- One-to-Many Relationship Model
- Many-to-Many Relationship Model
- One-to-One Relationship Model
- Explain Extended or Enhanced ER model in DBMS?
- Difference between Strong Entity and Weak Entity
- Explain difference between Strong Entity and Weak Entity
- Converting E-R model into relational model
- Comparison between E-R Model and Object Oriented Model
- Examples of E-R model
- Difference Between E-R Model and Relational Model in DBMS