Skip to main content
SpringerLink
Log in

The Entity-Relationship Model (Reprinted Historic Data)

  • Chapter
  • First Online:
Handbook of Conceptual Modeling

  • 2420 Accesses

Abstract

A data model, called the entity-relationship model, is proposed. This model incorporates some of the important semantic information about the real world. A special diagrammatic technique is introduced as a tool for database design. An example of database design and description using the model and the diagrammatic technique is given. Some implications for data integrity, information retrieval, and data manipulation are discussed.

The entity-relationship model can be used as a basis for unification of different views of data: the network model, the relational model, and the entity set model. Semantic ambiguities in these models are analyzed. Possible ways to derive their views of data from the entity-relationship model are presented.

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 129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 169.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

References

  1. Abrial, J.R. Data semantics. In Data Base Management, J.W. Klimbie and K. L. Koffeman, Eds., North-Holland Pub. Co., Amsterdam, 1974, pp. 1–60.

    Google Scholar 

  2. Bachman, C.W. Software for random access processing. Datamation 11 (April 1965), 36–41.

    Google Scholar 

  3. Bachman, C.W. Data structure diagrams. Data Base 1, 2 (Summer 1969), 4–10.

    Google Scholar 

  4. Bachman, C.W. Trends in database management—1975. Proc, AFIPS 1975 NCC, Vol. 44, AFIPS Press, Montvale, N.J., pp. 569–576.

    Google Scholar 

  5. Birkhoff, G., and Bartee, T.C. Modern Applied Algebra. McGraw-Hill, New York, 1970.

    MATH  Google Scholar 

  6. Chamberlin, D.D., and Raymond, F.B. Sequel: A structured English query language. Proc. ACM-SIGMOD 1974, Workshop, Ann Arbor, Michigan, May, 1974.

    Google Scholar 

  7. CODASYL. Data base task group report. ACM, New York, 1971.

    Google Scholar 

  8. Codd, E.F. A relational model of data for large shared data banks. Comm. ACM 13, 6 (June 1970), 377–387.

    Article  MATH  Google Scholar 

  9. Codd, E.F. Normalized data base structure: A brief tutorial. Proc. ACM-SIGFIDET 1971, Workshop, San Diego, Calif., Nov. 1971, pp. 1–18

    Google Scholar 

  10. Codd, E.F. A data base sublanguage founded on the relational calculus. Proc. ACM-SIGFIDET 1971, Workshop, San Diego, Calif., Nov. 1971, pp. 35–68.

    Google Scholar 

  11. Codd, E.F. Recent investigations in relational data base systems. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1017–1021.

    Google Scholar 

  12. Deheneffe, C., Hennebert, H., and Paulus, W. Relational model for data base. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1022–1025.

    Google Scholar 

  13. Dodd, G.G. Apl—a language for associate data handling in PL/I. Proc. AFIPS 1966 FJCC, Vol. 29, Spartan Books, New York, pp. 677–684.

    Google Scholar 

  14. Eswaran, K.P., and Chamberlin, D.D. Functional specifications of a subsystem for data base integrity. Proc. Very Large Data Base Conf., Framingham, Mass., Sept. 1975, pp. 48–68.

    Google Scholar 

  15. Hainaut, J.L., and Lecharlier, B. An extensible semantic model of data base and its data language. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 1026 - 1030.

    Google Scholar 

  16. Hammer, M.M., and Mcleod, D.J. Semantic integrity in a relation data base system. Proc. Very Large Data Base Conf., Framingham, Mass., Sept. 1975, pp. 25–47.

    Google Scholar 

  17. Lindgreen, P. Basic operations on information as a basis for data base design. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 993–997.

    Google Scholar 

  18. Mealy, G.H. Another look at data base. Proc. AFIPS 1967 FJCC, Vol. 31, AFIPS Press, Montvale, N.J., pp. 525–534.

    Google Scholar 

  19. Nijssen, G.M. Data structuring in the DDL and the relational model. In Data Base Management, J.W. Klimbie and K.L. Koffeman, Eds., North-Holland Pub. Co., Amsterdam, 1974, pp. 363–379.

    Google Scholar 

  20. Olle, T.W. Current and future trends in data base management systems. Proc. IFIP Congress 1974, North-Holland Pub. Co., Amsterdam, pp. 998–1006.

    Google Scholar 

  21. Roussopoulos, N., and Mylopoulos, J. Using semantic networks for data base management. Proc. Very Large Data Base Conf., Framingham, Mass., Sept. 1975, pp. 144–172.

    Google Scholar 

  22. Rustin, R. (Ed.). Proc. ACM-SOGMOD 1974—debate on data models. Ann Arbor, Mich., May 1974.

    Google Scholar 

  23. Schmid, H.A., and Swenson, J.R. On the semantics of the relational model. Proc. ACMSIGMOD 1975, Conference, San Jose, Calif., May 1975, pp. 211–233.

    Google Scholar 

  24. Senko, M.E. Data description language in the concept of multilevel structured description: DIAM II with FORAL. In Data Base Description, B.C.M. Dougue, and G.M. Nijssen, Eds., North-Holland Pub. Co., Amsterdam, pp. 239–258.

    Google Scholar 

  25. Senko, M.E., Altman E.B., Astrahan, M.M., and Fehder, P.L. Data structures and accessing in data-base systems. IBM Syst. J. 12, 1 (1073), 30–93.

    Google Scholar 

  26. Sibley, E.H. On the equivalence of data base systems. Proc. ACM-SIGMOD 1974 debate on data models, Ann Arbor, Mich., May 1974, pp. 43–76.

    Google Scholar 

  27. Steel, T.B. Data base standardization—a status report. Proc. ACM-SIGMOD 1975, Conference, San Jose, Calif., May 1975, pp. 65–78.

    Google Scholar 

  28. Stonebraker, M. Implementation of integrity constraints and views by query modification. Proc. ACM-SIGMOD 1975, Conference, San Jose, Calif., May 1975, pp. 65–78.

    Google Scholar 

  29. Sundgren, B. Conceptual foundation of the infological approach to data bases. In Data Base Management, J.W. Klimbie and K.L. Koffeman, Eds., North-Holland Pub. Co., Amsterdam, 1974, pp. 61–95.

    Google Scholar 

  30. Taylor, R.W. Observations on the attributes of database sets. In Data Base Description, B.C.M. Dougue and G.M. Nijssen, Eds., North-Holland Pub. Co., Amsterdam, pp. 73–84.

    Google Scholar 

  31. Tsichritzis, D. A network framework for relation implementation. In Data Base Description, B.C.M. Douge and G.M. Nijssen, Eds., North-Holland Pub. Co., Amsterdam, pp. 269–282.

    Google Scholar 

Download references

Author information

Author notes

  1. Peter Pin-Shan Chen

    Present address: Alfred P. Sloan School of Management, Center for Information System Research, MIT, Cambridge, MA, USA

Authors and Affiliations

    Authors
    1. Peter Pin-Shan Chen
      View author publications

      You can also search for this author in PubMed Google Scholar

    Editor information

    Editors and Affiliations

    1. , Department of Computer Science, Brigham Young University, Provo, 84602, USA

      David W. Embley

    2. Institut für Informatik, Christian-Albrechts-Universität zu Kiel, Olshausenstr. 40, Kiel, 24098, Germany

      Bernhard Thalheim

    Rights and permissions

    Reprints and permissions

    Copyright information

    © 2011 Springer-Verlag Berlin Heidelberg

    About this chapter

    Cite this chapter

    Chen, PS. (2011). The Entity-Relationship Model (Reprinted Historic Data). In: Embley, D., Thalheim, B. (eds) Handbook of Conceptual Modeling. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15865-0_3

    Download citation

    • DOI: https://doi.org/10.1007/978-3-642-15865-0_3

    • Published:

    • Publisher Name: Springer, Berlin, Heidelberg

    • Print ISBN: 978-3-642-15864-3

    • Online ISBN: 978-3-642-15865-0

    • eBook Packages: Computer ScienceComputer Science (R0)

    Publish with us

    Policies and ethics

    Search

    Navigation