entity-relationship model

(redirected from E-R diagram)

entity-relationship model

(database, specification)
An approach to data modelling proposed by P. Chen in 1976. The model says that you divide your database in two logical parts, entities (e.g. "customer", "product") and relations ("buys", "pays for").

Entity-relationship diagrams can be used to represent a model.

["The entity-relationship model: toward a unified view of data", P.P. Chen, ACM Transactions on Database Systems 1:1 pp 9-36, 1976].
References in periodicals archive ?
Like the E-R diagram, it also shows the tables and their relationships.
As already mentioned, the step in conceptual data modeling is to identify entity types and to draw an E-R diagram. Developing an E-R diagram has traditionally taken one (or both) of two non-normative approaches (Teorey, Yang, & Fry, 1986).
At the heart of such an important task is the requirement to identify entity types completely before we begin drawing E-R diagrams. This paper has introduced a novel, yet clean, method for entity type identification, for conceptual data modeling.
In many situations the E-R diagram might already be available - for example, if the target application is a hypermedia interface to an existing database.
Figure 5 shows the E-R diagram for the handbook application.
To differentiate them from the associative relationships appearing in the E-R diagram. Structural links differ from associative relationships in that the former connect information pieces within the same entity instance, while the latter interconnect different entity instances belonging, in most cases, to different entity classes.
This paper will present the E-R diagrams and table designs for the databases associated with shopping carts of each Tier, as well as suggestions for appropriate use of tiered shopping carts.
However, our experience has shown that E-R diagrams must be simple for user representatives to review and improve.