Difference between revisions of "Entity-relationship model"
Karl Jones (Talk | contribs) |
Karl Jones (Talk | contribs) (→External links) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 21: | Line 21: | ||
== History == | == History == | ||
| − | + | Entity-relationship modeling was developed by Peter Chen and published in a 1976 paper. However, variants of the idea existed previously, and have been devised subsequently such as supertype and subtype data entities and commonality relationships. | |
== See also == | == See also == | ||
| Line 30: | Line 30: | ||
* [[Information]] | * [[Information]] | ||
* [[Model]] | * [[Model]] | ||
| − | * [[Relational database]] | + | * [[Relational database]] |
* [[Software engineering]] | * [[Software engineering]] | ||
| Line 36: | Line 36: | ||
* [https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model Entity–relationship model] | * [https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model Entity–relationship model] | ||
| + | |||
| + | [[Category:Computer science]] | ||
| + | [[Category:Databases]] | ||
| + | [[Category:Models]] | ||
| + | [[Category:Software development]] | ||
Latest revision as of 15:57, 24 April 2016
In software engineering, an entity–relationship model (ER model) is a data model for describing the data (computing) or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a database such as a relational database.
Contents
Description
The main components of ER models are entities (things) and the relationships that can exist among them.
An entity–relationship model is a systematic way of describing and defining a business process.
The process is modeled as components (entities) that are linked with each other by relationships that express the dependencies and requirements between them.
For example, one building may be divided into zero or more apartments, but one apartment can only be located in one building.
Entities may have various properties (attributes) that characterize them.
Diagrams created to represent these entities, attributes, and relationships graphically are called entity–relationship diagrams.
An ER model is typically implemented as a database. In the case of a relational database, which stores data in tables, every row of each table represents one instance of an entity. Some data fields in these tables point to indexes in other tables; such pointers represent the relationships.
The three schema approach to software engineering uses three levels of ER models that may be developed.
History
Entity-relationship modeling was developed by Peter Chen and published in a 1976 paper. However, variants of the idea existed previously, and have been devised subsequently such as supertype and subtype data entities and commonality relationships.
See also
- Associative entity
- Data model
- Data (computing)
- Information
- Model
- Relational database
- Software engineering
