Skip to main content
SpringerLink
Log in

Extended Entity-Relationship Model

  • Reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 54 Accesses

Synonyms

EERM, HERM; Hierarchical entity-relationship model; Higher-order entity-relationship model

Definition

The extended entity-relationship (EER) model is a language for defining the structure (and functionality) of database or information systems. Its structure is developed inductively. Basic attributes are assigned to general base data types. Complex attributes can be constructed by applying constructors such as tuple, list, or set constructors to attributes that have already been constructed. Entity types conceptualize structuring of things of reality through attributes. Cluster types generalize types or combine types into singleton types. Relationship types associate types that have already been constructed into an association type. The types may be restricted by integrity constraints and by specification of identification of objects defined for a type. Typical integrity constraints of the extended entity-relationship model are participation, look-across, and general...

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

  1. Chen PP. The entity-relationship model: toward a unified view of data. ACM Trans Database Syst. 1976;1(1):9–36.

    Article  Google Scholar 

  2. Embley D, Thalheim B, editors. Handbook of conceptual modelling: its usage and its challenges. Springer; Berlin 2011.

    Google Scholar 

  3. Gogolla M. An extended entity-relationship model – fundamentals and pragmatics. LNCS, vol. 767. Berlin: Springer; 1994.

    Book  MATH  Google Scholar 

  4. Hartmann S. Reasoning about participation constraints and Chen’s constraints. In: The Fourteenth Australian Database Conference, Adelaide, Australia. Conferences in Research and Practice in Information Technology; 2003. p. 105–13.

    Google Scholar 

  5. Hartmann S, Hoffmann A, Link S, Schewe K-D. Axiomatizing functional dependencies in the higher-order entity-relationship model. Inf Process Lett. 2003;87(3):133–7.

    Article  MathSciNet  MATH  Google Scholar 

  6. Hohenstein U. Formale Semantik eines erweiterten Entity-Relationship-Modells. Stuttgart: Teubner; 1993.

    Book  MATH  Google Scholar 

  7. Liddle SW, Embley DW, Woodfield SN. Cardinality constraints in semantic data models. Data Knowl Eng. 1993;11(3):235–70.

    Article  MATH  Google Scholar 

  8. Schewe K-D, Thalheim B. Conceptual modelling of web information systems. Data Knowl Eng. 2005;54(2):147–88.

    Article  Google Scholar 

  9. Thalheim B. Dependencies in relational databases. Leipzig: Teubner; 1991.

    Book  MATH  Google Scholar 

  10. Thalheim B. Entity-relationship modeling – foundations of database technology. Berlin: Springer; 2000.

    Book  MATH  Google Scholar 

  11. Thalheim B. Codesign of structuring, functionality, distribution and interactivity. Aust Comput Sci Commun. 2004;31(6):3–12.

    Google Scholar 

  12. Thalheim B. Open problems of information systems research and technology. In: Proceedings of the 12th International Conference on Perspectives in Business Informatics Research. Lecture Notes in Business Information Processing; 2013. p. 10–8.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Christian-Albrechts University, Kiel, Germany

    Bernhard Thalheim

Authors
  1. Bernhard Thalheim
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Bernhard Thalheim .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Thalheim, B. (2018). Extended Entity-Relationship Model. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_157

Download citation

Publish with us

Policies and ethics

Search

Navigation