ALERT

[WEBINAR] Index Insanity: How to Avoid Database Chaos

Entity-Relationship Model (ER Model)

Definition - What does Entity-Relationship Model (ER Model) mean?

An entity-relationship model (ERM) is a theoretical and conceptual way of showing data relationships in software development. ERM is a database modeling technique that generates an abstract diagram or visual representation of a system’s data that can be helpful in designing a relational database. These diagrams are known as entity-relationship diagrams, ER diagrams or ERDs.

Entity-relationship patterns were first proposed by Peter Pin-Shan Chen of the Massachusetts Institute of Technology (MIT) in 1976.

Techopedia explains Entity-Relationship Model (ER Model)

The first step in information system design dictates that the requirements analysis models illustrate the type of data or information that needs to be collected. The data modeling method may be used to illustrate a specific interest area’s ontology. Like the relational model, abstract data is converted to a logical data model when the design of an information system is built on a database. Likewise, this is converted to a physical model when it is physically designed.

The building blocks of an ERD are entities, relationships and attributes. Entities have entity types, which are known as instances of the corresponding entities. Each entity type can exist independently of another; for example, the entity "vehicle" can have the entity types "car" and "bus". Relationship is the property that links the entity types together. For example, the entity type husband is related to the entity type wife by a relationship known as "is-married-to." Attributes are properties that belong to the entity types as well as to the relationships.

There are a number of ER diagramming tools available on the market. The most common ones are MySQL Workbench and OpenModelSphere.

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.