- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
Explain Extended or Enhanced ER model in DBMS?
Extended ER is a high-level data model that incorporates the extensions to the original ER model. Enhanced ER models are high level models that represent the requirements and complexities of complex databases.
The extended Entity Relationship (ER) models are three types as given below −
Aggregation
Specialization
Generalization
Specialization
The process of designing sub groupings within an entity set is called specialization. It is a top-down process. If an entity set is given with all the attributes in which the instances of the entity set are differentiated according to the given attribute value, then that sub-classes or the sub-entity sets can be formed from the given attribute.
Example
Specialization of a person allows us to distinguish a person according to whether they are employees or customers. Specialization of account creates two entity sets: savings account and current account.
In the E-R diagram specialization is represented by triangle components labeled ISA. The ISA relationship is referred as superclass- subclass relationship as shown below −
Generalization
It is the reverse process of specialization. It is a bottom-up approach.
It converts subclasses to superclasses. This process combines a number of entity sets that share the same features into higher-level entity sets.
If the sub-class information is given for the given entity set then, ISA relationship type will be used to represent the connectivity between the subclass and superclass as shown below −
Example
Aggregation
It is an abstraction in which relationship sets are treated as higher level entity sets and can participate in relationships. Aggregation allows us to indicate that a relationship set participates in another relationship set.
Aggregation is used to simplify the details of a given database where ternary relationships will be changed into binary relationships. Ternary relation is only one type of relationship which is working between three entities.
Aggregation is shown in the image below −
- Related Articles
- What is an ER model in DBMS?
- What are constraints on ER model in DBMS?
- Explain the components of the ER diagram in DBMS?
- Explain the conversion of ER diagrams to tables in DBMS?
- Explain the Network Model in DBMS?
- Explain the Relational Model in DBMS?
- Explain Mapping the ER diagrams with binary and ternary relationships(DBMS)?
- Explain the object oriented data model in DBMS?
- Attributes to Relationships in ER Model
- Generalization, Specialization and Aggregation in ER Model
- What are the components of ER diagrams in DBMS?
- Construct an ER diagram for a company in DBMS?
- Construct an ER diagram for the Banking system in DBMS?
- Extended Entity-Relationship (EE-R) Model
- Draw an ER diagram for a University database application(DBMS)?
