Enhanced entity–relationship model

From Infogalactic: the planetary knowledge core
Jump to: navigation, search

The enhanced entity–relationship (EER) model (or extended entity–relationship model) in computer science is a high-level or conceptual data model incorporating extensions to the original entity–relationship (ER) model, used in the design of databases.

It was developed to reflect more precisely the properties and constraints that are found in more complex databases, such as in engineering design and manufacturing (CAD/CAM), telecommunications, complex software systems and geographic information systems (GIS).

Mechanics

<templatestyles src="Module:Hatnote/styles.css"></templatestyles>

The EER model includes all of the concepts introduced by the ER model. Additionally it includes the concepts of a subclass and superclass (Is-a), along with the concepts of specialization and generalization. Furthermore, it introduces the concept of a union type or category, which is used to represent a collection of objects that is the union of objects of different entity types.

Subclass and superclass

Entity type Y is a subtype (subclass) of an entity type X if and only if every Y is necessarily an X. A subclass entity inherits all attributes and relationships of its superclass entity. This property is called the attribute and relationship inheritance. A subclass entity may have its own specific attributes and relationships (together with all the attributes and relationships it inherits from the superclass). Most common superclass examples is a vehicle with subclasses of Car and Truck. There are a number of common attributes between a car and a truck, which would be part of the Superclass, while the attributes specific to a car or a truck (such as max payload, truck type...) would make up two subclasses.

Tools

Lua error in package.lua at line 80: module 'strict' not found.

  • The MySQL Workbench offers creating, editing and exporting EER Models. Exporting to PNG and PDF allows easy sharing for presentations.
  • Skipper allows to create, import and export from ORM schema definitions to editable EER models.

See also

References

Lua error in package.lua at line 80: module 'strict' not found.

Further reading

Textbooks discussing EER and implementation using purely relational databases:

  • Lua error in package.lua at line 80: module 'strict' not found.
  • Lua error in package.lua at line 80: module 'strict' not found.
  • Lua error in package.lua at line 80: module 'strict' not found.

Booklet discussing EER and implementation using object-oriented and object-relational databases:

  • Lua error in package.lua at line 80: module 'strict' not found.

Textbook discussing implementation in relational and object-relational databases:

  • Lua error in package.lua at line 80: module 'strict' not found.

Shorter survey articles:

  • Lua error in package.lua at line 80: module 'strict' not found.
  • Lua error in package.lua at line 80: module 'strict' not found.

External links

  • [1] - Slides for chapter 8 from Fundamentals of Database Systems by Elmasri and Navathe (Pearson, 2011)
  • [2] - Lecture notes from the University of Toronto
  • [3] - The ER Conference


<templatestyles src="Asbox/styles.css"></templatestyles>