Published Online: 15 SEP 2008
Copyright © 2007 by John Wiley & Sons, Inc.
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.
- Published Online: 15 SEP 2008
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.
- entity-relationship model;
- data model;
- normal form;
- conceptual database design;
- logical database design