Entity Relationship Model
Entity-relationship model; ER Model; ERM
The entity relationship model (ERM) is a conceptual model that represents the information structure of a problem domain in terms of entities and relationships. The result of modeling using the ERM is graphically represented as an entity relationship diagram (ERD). Thus, an ERD represents the conceptual structure of a problem domain being modeled. ERDs are widely used in database design and systems analysis to capture requirements of a system or a problem domain. In particular, when used for data modeling, the ERD assists the database designer in identifying both the data and the rules that are represented and used in a database. ERDs are readily translated into relational database schemas.
The ERM was introduced by Peter Chen in 1976 . The ERM and its variations have been widely used in database modeling and design, systems analysis and design methodologies, computer-aided software engineering (CASE)...
- 4.Chen PP. Entity-relationship modeling: historical events, future trends, and lessons learned. In: Broy M, Denert E, editors. Software pioneers: contributions to software engineering. New York: Springer; 2002. p. 100–14.Google Scholar
- 7.ER conferences. Available at: http://conceptualmodeling.org
- 8.Ling TW. A normal form for entity-relationship diagrams. In: Proceedings of 4th International Conference on Entity-Relationship Approach. IEEE Computer Society; 1985. p. 24–35.Google Scholar
- 9.Song I-Y, Evans M, Park EK. A comparative analysis of entity-relationship diagrams. J Comput Softw Eng. 1995;3(4):427–59.Google Scholar