Standard Article

Entity-Relationship Model

  1. Tok Wang Ling1,
  2. Mong Li Lee2

Published Online: 15 SEP 2008

DOI: 10.1002/9780470050118.ecse501

Wiley Encyclopedia of Computer Science and Engineering

Wiley Encyclopedia of Computer Science and Engineering

How to Cite

Ling, T. W. and Lee, M. L. 2008. Entity-Relationship Model. Wiley Encyclopedia of Computer Science and Engineering. 1–10.

Author Information

  1. 1

    National University of Singapore

  2. 2

    National University of Singapore

Publication History

  1. Published Online: 15 SEP 2008

Abstract

Data modeling is an important phase in the development of a database system. The Entity-Relationship (ER) model was introduced by Peter Chen in 1977. This model has been widely used for conceptual data modeling and has become a tool for communication between database designers and end users at the analysis phase of database development. This article presents the main constructs of the ER model, namely, entities and relationships and their associated attributes, as well as some of its extensions. We also discuss how conceptual database design can be carried out using the ER model, the normal form ER diagram and the translation of ER diagrams to the relational model.

Keywords:

  • entity-relationship model;
  • data model;
  • normal form;
  • conceptual database design;
  • logical database design