entity-relationship model


Also found in: Wikipedia.

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 ?
The authors have organized the main body of their text in fifteen chapters devoted to introductory database concepts, database planning and architecture, the entity-relationship model, the relational model, and many other related subjects.
(1976), The Entity-Relationship Model: Towards a Unified View of Data, ACM Transaction on Database Systems, vol.
Improved Visual Entity-Relationship Model Synchronization: with live schemas, making the integrated database modeling tool even more useful for managing schemas.
(12) The analytical technique used was derived from systems-development methods, particularly the entity-relationship model popularized in the academic community by Peter Chen and reported in his 1976 work with reference to datasets relevant to business functions.
These methods attempt to extract the conceptual schema from an operational legacy system and express the schema in some variant of the entity-relationship model (ER, EER, ECR) or of the object-oriented model (OMT).
In the following we first present the gist of the Entity-Relationship model as our basis for schema design following [18].
A logical design methodology for relational databases using the extended entity-relationship model. ACM Computing Surveys, 18(2), 197-222.
This EOEDM is a meta-level modeling schema, exploiting the entity-relationship model in database design as well as the object model in application design.
This is illustrated with an entity-relationship model, one of the two principal approaches used in this book.
Codd's ideas on relational systems (1970, 1972b) and syntactic normalization (1972a) had proven superior in most conceptual and logical respects to the older classes of implementation platforms such as network and hierarchical systems, and Abrial's (1974) paper had signaled the advent of the semantic database era that would culminate soon thereafter with the publications of Chen's (1976) entity-relationship model and Smith and Smith's (1977) data abstraction ideas.
Fidel & Crandall (1988) described the Anglo-American cataloguing rules from a generalized database approach, using the entity-relationship model to suggest a problem-based typology of rules that might underlie a theoretical framework of rules for bibliographic database design.