Enhanced Entity-Relationship(EER) Model

Enhanced Entity-Relationship(EER) Model

Handwritten Notes- Click Here


The Enhanced Entity-Relationship (EER) Model is an extended form of the traditional Entity-Relationship (ER) Model.

The basic ER model is useful for representing entities, attributes, and relationships. However, some real-world database applications contain more complex structures such as different types of entities, inheritance, and hierarchical relationships.

The EER model adds additional concepts to the ER model so that these complex requirements can be represented more clearly.

The important concepts of the EER Model include:

  • Superclass and Subclass
  • Specialization
  • Generalization
  • Inheritance
  • Disjoint and Overlapping Constraints
  • Total and Partial Specialization
  • Aggregation

1. Superclass and Subclass

  • A superclass is a higher-level entity that contains common attributes shared by different entities.
  • A subclass is a lower-level entity that contains attributes specific to that particular entity. A subclass inherits the attributes and relationships of its superclass.
  • This concept is called inheritance. It helps reduce redundancy and makes the database design easier to understand.
Example: Employee Superclass
  • Consider Employee as a superclass. It contains common attributes such as Emp_ID, Name, and Salary.
  • The subclasses are Engineer, Technician, and Secretary. Each subclass has its own additional attributes.
  1. Engineer has Skill.
  2. Technician has Grade.
  3. Secretary has Typing Speed.


2. Specialization (Bottom-Up Approach)
  • Specialization is the process of dividing a superclass into subclasses based on unique features or characteristics.
  • It follows a bottom-up approach.
  • For example, a Vehicle superclass can be divided into the subclasses Car and Truck.



3. Generalization (Top-Down Approach)

  • Generalization is the reverse of specialization. It combines multiple similar entities into one common superclass.
  • It follows a top-down approach

Example: Vehicle Generalization

  • Car and Truck are similar entities because both represent vehicles. Therefore, they can be generalized into a Vehicle superclass.
  • The common attributes of Vehicle may include Vehicle_ID and Price.


Video Explanation- Click Here

Comments

Post a Comment

Popular posts from this blog

Queue ADT

Image
  Queue ADT Handwritten Notes- Click Here A  Queue  is a linear data structure in which elements are inserted at one end and removed from the other end.( Insertion → Rear,  Deletion → Front )                                   ↓ FRONT                                 ↓ REAR A B C D E    A queue follows the FIFO (First In, First Out) principle. This means that the element inserted first is removed first. A  Queue can be implemented using: Array Linked List Basic  Queue  Operations: 1. Enqueue - used to insert  a new element into the queue. 2. Dequeue - used to remove an element from the queue. 3. Peek - used to view the first element without removing it. 4. isEmpty - checks whether the queue contains any elements. 5...
Read more

Entity-Relationship(ER) Model

Image
Entity-Relationship(ER) Model Handwritten Notes - Click Here The Entity-Relationship (ER) Model is a conceptual data model. It helps database designers understand the requirements of a system before creating the actual database tables . It describes the important objects in a system, their properties , and the relationships between them. The three basic concepts of the ER model are Entity Attribute Relationship Entity An entity can be any real-world object, person, place, or class about which we want to store information in a database. In a traditional ER diagram, an entity is represented by a rectangle .                        Example: Employee and Department An employee works for a department. Here, Employee and Department are entities , and Works For is the relationship between them. Weak Entity A weak entity is an entity that depends on another entity for its identification of existence. A weak entity is represen...
Read more

Different types of Data Models in DBMS

Image
             Data Models Handwritten Notes- Click Here A Data Model defines how data is organized, stored, related, and accessed in a database. Types of Data Models in DBMS Hierarchical Data Model Network Data Model Relational Data Model Entity-Relationship (ER) Model Object-Oriented Data Model Object-Relational Data Model 1. Hierarchical Data Model   The Hierarchical Data Model organizes data in the form of a tree structure . Each child record has only one parent record . A parent record can have multiple child records . It mainly represents a one-to-many relationship . Data retrieval is very fast in the hierarchical model.                                   Company                   |            Department             /      ...
Read more