Why are entity relationship diagrams used?
Entity Relationship (ER) diagrams are drawn when designing a database system, After the systems specification, an ER diagram is drawn showing the conceptual design of the database, this diagram shows the type of information that is to be stored in the system and how these information associate with each other (e.g. one-to-one, one-to-many, etc).
ER Diagrams are simple and easy to understand, thus, this
diagram can be shown and explained to user representatives for
confirmation and approval.
use of er diagram
Entity-Relationship diagrams are useful for modelling data and the relationships between the data. They can be used when the constraints between data are relatively simple. They do not allow specification of interactions between the data or model how the data changes (there are no processes in Entity-Relationship). Entity-Relationship diagrams are most often used to model databases.
In software engineering, an Entity - Relationship model (ER model for short) is an abstract and conceptual representation of data. Entity-relationship modeling is a database modeling method, used to produce a type of conceptual schema or semantic data model of a system, often a relational database, and its requirements in a top-down fashion. Diagrams created by this process are called entity-relationship diagrams or ER diagrams. learn more www.ngprakasam.hpage.com
Entity Relationship Diagrams (ERD's) are a way of diagrammatically showing entities in an organisations and how they relate to each other. ERD's show detailed representations of the information that is used in a system and how it relates to other data. There are a number of symbols that represent the entities and the relationships between them; the relationship can be a one to many relationship, many to many or one to one.
An entity relationship diagram (ERD) represents the entities, or groups of information, and their relationships maintained for a business. An entity relationship diagram represents the entities, or groups of information, and their relationships maintained for a business. An entity relationship diagram represents the entities, or groups of information, and their relationships maintained for a business.
In contrast to the strong or regular entity, a weak entity is one that meets two conditions: 1. The entity is existence-dependent; that is, it cannot exist without the entity with which it has a relationship. 2. The entity has a primary key that is partially or totally derived from the parent entity in the relationship.
An E-R diagram may also indicate the cardinality of a relationship. Cardinality is the number of instances of one entity that can, or must, be associated with each instance of another entity. In general we may speak of one-to-one, one-to-many, or many-to-many relationships. There are several different styles used to draw Entity-Relationship diagrams. The Kendall and Kendall text uses the Crow's Foot notation. Using this notation entities are represented by rectanges and relationships are indicated…