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
≈ 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:
External links
- 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.