E-R

(redirected from Entity-relationship)
Also found in: Encyclopedia.
AcronymDefinition
E-REntity-Relationship
References in periodicals archive ?
The Entity-Relationship Model is a data modeling method in the database concept that produces a conceptual schema or semantic data model of a relational database.
The sources of the entity-relationship model incorporated in the FRBR report are given early in the document.
In the following we first present the gist of the Entity-Relationship model as our basis for schema design following [18].
Conceptual database design: an Entity-relationship approach.
Aqua Data Studio's Entity-Relationship Modeler has also been extended, and now has the ability to convert or translate an ER model from one database to another, along with the ability to export to ERX format, import object schemas into existing databases and compare schema objects of different models within the same or different databases.
Readers should already be familiar with the basics of relational and Entity-Relationship models, as well as with information systems and information system design.
Basically, FRBR uses entity-relationship modeling to structure a bibliographic database in an entirely new way.
They include the Entity-Relationship (ER) modeling introduced by Chen (1976) and dimensional modeling including the Star Schema and Snowflake Schema, which utilize fact tables and dimension tables (Todman 2001).
This is illustrated with an entity-relationship model, one of the two principal approaches used in this book.
Chen is recognized for his Entity-Relationship (ER) model, as well as many other contributions.
SQL-Tutor teaches the SQL query language, NORMIT is a data normalization tutor, and KERMIT teaches conceptual database modeling using the Entity-Relationship data model.
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.