enhanced entity–relationship model

enhancement of the ER model that describes inter-related things of interest in a specific domain of knowledge with subclass / inheritance support

Uses your system voice; voice and rate in settings.

Q5378800Snapshot

≈ 2 min read

Names in other languages

  • УкраїнськаРозширена модель «сутність — зв'язок»
  • Englishenhanced entity–relationship model
  • nbforbedret entitet-relasjonsmodell
  • FrançaisModèle entité-association étendu
  • SvenskaEER-modell
  • 日本語拡張実体関連モデル
  • 中文增强实体联系模型

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

The Enhanced Entity–Relationship (EER) model is an extended version of the Entity–Relationship (ER) model used in database design. It incorporates additional semantic constructs and modeling capabilities beyond the basic ER model, enabling more accurate representation of complex real-world scenarios through concepts such as specialization, generalization, union types, and inheritance.

The EER model was developed in the 1980s by database researchers including Ramez Elmasri and Shamkant Navathe to address the limitations of the basic ER model when modeling complex databases in domains such as engineering design, manufacturing systems (CAD/CAM), telecommunications networks, geographic information systems (GIS), and complex software applications.

Tools

Numerous tools support EER diagram creation, ranging from specialized database design software to general-purpose diagramming applications.

See also

Object–relational database Slowly changing dimension Structured type

Further reading

Textbooks discussing EER and implementation using purely relational databases: Booklet discussing EER and implementation using object-oriented and object–relational databases: Textbook discussing implementation in relational and object–relational databases: Shorter survey articles:

- Slides for chapter 8 from Fundamentals of Database Systems by Elmasri and Navathe (Pearson, 2011) - Lecture notes from the University of Toronto [http://www.conceptualmodeling.org/ - The ER Conference

Text derived from https://en.wikipedia.org/w/index.php?oldid=1374244230 under CC BY-SA 4.0; modifications have been made.

Provenance

snapshot enhanced-entity-relationship-model-612498-924d1d3badb371bc · hash 924d1d3badb371bc10dde1650bce356e5cfe83e4026b3de1b1862555a6fa3098 · captured 1789061951.0 · version history

Cite this page as: encyclopegia.org, “enhanced entity–relationship model”, snapshot enhanced-entity-relationship-model-612498-924d1d3badb371bc. https://encyclopegia.org/a/enhanced-entity-relationship-model

Sources cited in this revision

No external citation was extracted for this revision. That is a statement about the source, not a claim that none exists.