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.
(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 .
A logical design methodology for relational databases using the extended entity-relationship model
. ACM Computing Surveys, 18(2), 197-222.
MoReq2 uses a new entity-relationship model
, one that is clearer and more straightforward than MoReq's model, but at the same time richer.
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.