entity relationship model


Also found in: Dictionary, Medical, Acronyms.

entity relationship model

A database model that describes the attributes of entities and the relationships among them. An entity is a file (table). Today, ER models are often created graphically, and software converts the graphical representations of the tables into the SQL code required to create the data structures in the database. See data model and dimensional modeling.


Building an Entity Relationship Model
The Erwin modeling program from CA Technologies stands for Entity Relationship for Windows. In this order processing example, the tables for customers and orders are drawn graphically, and Erwin turns the graph into the appropriate SQL code for the target database. (Example courtesy of CA Technologies, Inc.)
References in periodicals archive ?
This can lead to overlooking or discounting of business rules that would be much more apparent in a traditional Entity Relationship model. For example, if a sales organization represented a product in the following fashion.
The entity relationship model - Towards a unified view of data.
The modeling language used is an extension to the Entity Relationship Model (5) (ERM) which is most commonly used because of its user-friendly graphical representation and its close ties to other database models such as the relational, the network and the emerging object-oriented models.