entity-relationship diagram

The three main components of an ERD are:

• The entity is a person, object, place or event for which data is collected. For example, if you consider the information system for a business, entities would include not only customers, but the customer's address, and orders as well. The entity is represented by a rectangle and labelled with a singular noun.
• The relationship is the interaction between the entities. In the example above, the customer places an order, so the word "places" defines the relationship between that instance of a customer and the order or orders that they place. A relationship may be represented by a diamond shape, or more simply, by the line connecting the entities. In either case, verbs are used to label the relationships.
• The cardinality defines the relationship between the entities in terms of numbers. An entity may be optional: for example, a sales rep could have no customers or could have one or many customers; or mandatory: for example, there must be at least one product listed in an order. There are several different types of cardinality notation; crow's foot notation, used here, is a common one. In crow's foot notation, a single bar indicates one, a double bar indicates one and only one (for example, a single instance of a product can only be stored in one warehouse), a circle indicates zero, and a crow's foot indicates many. The three main cardinal relationships are: one-to-one, expressed as 1:1; one-to-many, expressed as 1:M; and many-to-many, expressed as M:N.

The steps involved in creating an ERD are:

• Identify the entities.
• Determine all significant interactions.
• Analyze the nature of the interactions.
• Draw the ERD.

A number of CASE tools, such as Visible Analyst and Data Architect, can be used to generate ERDs.

Do you have something to add to this definition? Let us know. Send your comments to techterms@whatis.com

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Using the customer database to provide good customer experiences Expert Lior Arussy offers advice on how to use a company's customer database to provide positive customer experiences. Data breach notification must demonstrate commitment to customer service Plan for a data breach and you'll be prepared when you need to notify customers. Lior Arussy advises that you focus on four things when reacting to a... A true view of the customer requires data 'symbiosis' Data quality is not enough by itself. Organizations need to complement it with data integration to preserve customer service and changing processes.

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary cooked data  (SearchCRM.com) COPPA  (SearchCRM.com) The Children's Online Privacy Protection Act (COPPA) is a law passed by the U.S. Congress in 1998 to specifically protect the privacy of children...