Loading...

Entity-Relationship Diagram Tutorial | ER Diagram Tutorial Part 1

407,774 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Nov 27, 2013

Entity-Relationship Diagram Tutorial

An Entity-Relationship diagram (ERD) typically serves as the main deliverable of a conceptual data model. While newer approaches to E-R modeling have developed, the E-R approach is still cited by some professionals as "the premier model for conceptual database design". An ERD is a logical representation of an organization's data, and consists of three primary components:

Entities -- Major categories of data and are represented by rectangles
Attributes -- Characteristics of entities and are listed within entity rectangles
Relationships -- Business relationships between entities and are represented by lines
An Entity is a person, place, object, event, or concept that an organization wants to maintain data on. Each entity has a unique identity that differentiates it from other entities. A point of distinction must be made between entity types and entity instances. An entity type is a collection of entities that share common properties. Entity types are also known as entity classes. An entity instance is an individual occurrence of an entity type. A data model describes an entity type only once; however there may be numerous instances of that type within a database.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...