Intro to Entity-Relationship Model

This lesson introduces the concept of entity-relationship model.

The entity-relationship data model

The entity-relationship (ER) data model is a high-level conceptual data model that has existed for over 35 years. It is well suited to data modeling for use with databases because it is fairly abstract and is easy to discuss and explain. ER models, also called ER schemas, are represented by ER diagrams.

ER modeling is based on two concepts:

  • Entities, defined as tables that hold specific information (data).

  • Relationships, defined as the associations or interactions between entities.

Here is an example of how these two concepts might be combined in an ER data model: Prof. Lawrence (entity) teaches (relationship) the database systems course (entity).

Get hands-on with 1200+ tech skills courses.