Register | Login

Entity Relationship Diagrams

Posted by jyothsnav 2468 days ago (Editorial)

There are serveral notations for data modeling. The actual model is frequently called Entity Relationship model, because it depicts data in terms of the entities and relationships described in the data. An entity -relationship model (ERM) is an abstract conceptual representation of structured data. Entity-relationship modeling is a relational schema database modeling method, used in software engineering to produce a type of conceptual data model or semantic data model of a system, often a relational database, and its requirements in a top-down fashion.


Several techiniques have been developed for the design of data models. Main notation is IDEF1X (Integration Definition for Information Modeling). IDEF1X is used to produce a graphical information model which represents the structure and semantics of information within an environment or system.

The primary objectives of the IDEF1X standard are to provide:

  • Means for completely understanding and analyzing an organization's data resources;

  • Common means of representing and communicating the complexity of data;

  • A technique for presenting an overall view of the data required to run an enterprise;

  • Means for defining an application-independent view of data which can be validated by users and transformed into a physical database design; and

  • A technique for deriving an integrated data definition from existing data resources.

Who Voted for this Article, is a website that will allow everyone to share their knowledge, tip or information through community micro blogging.