11.1 Why Enhanced ER (EER)?

Basic ER models are great for traditional applications, but they struggle with complex data (like CAD/CAM, GIS, or medical systems). The EER Model adds concepts like Subclasses and Superclasses.

11.2 Superclasses and Subclasses

• Superclass: A generic entity type that contains common attributes (e.g., EMPLOYEE).
• Subclass: A specialized group of entities that inherit attributes from the superclass but have their own specific ones (e.g., SECRETARY, ENGINEER).

11.3 Specialization (Top-Down)

Specialization is the process of defining a set of subclasses of an entity type.

• Example: We specialize EMPLOYEE based on job type into {MANAGER, SALESMAN, OFFICER}.
• Inheritance: An entity in a subclass "IS-A" member of the superclass. It inherits all attributes (Name, SSN) and relationships of the superclass.

11.4 Generalization (Bottom-Up)

Generalization is the reverse of specialization. We take several entity types with common features and suppress their differences to create a single superclass.

• Example: We have CAR and TRUCK. We generalize them into VEHICLE.
• Attributes like Price and LicenseNumber move to the superclass.

11.5 Summary of IS-A Relationship

The relationship between a subclass and a superclass is called an IS-A relationship.

• A Secretary is an Employee.
• An Engineer is an Employee.