Site icon

Entity-Relationship Model


In this tutorial, we will learn about relational database design using the most common entity-relationship model. An Entity-relationship Model (in short, ER model) describes the structure of a database using a diagram known as an Entity Relationship Diagram(ER Diagram).  An ER model is a design or blueprint for a database that can later be implemented.

This Model uses a top-down method to model a relational database. It starts with an overall black box view and then adds detail as the process is refined. The product of this modeling process is an Entity-Relationship Diagram (ERD).

Entities and Relationships

The main components of an E-R model are as follows:

Entity Relationship Diagram

An ER diagram shows the relationship among entity sets. An entity set is a group of similar entities, and these entities can have attributes. In terms of DBMS, an entity is a table or attribute of a table in a database, so by showing the relationship among tables and their attributes, an ER diagram shows the complete logical structure of a database.

The outcome or product of the database modeling process is a diagram called an Entity-Relationship Diagram(ER Diagram, or in short, ERD ). The Entity-Relationship Diagram is a high-level graphical description of a data model. We can use this model diagram to assist in the database design.

There are multiple ERD types, and they are used at different stages of database modeling. Popular ER model notations are as follows:

Crow’s foot notation is one of the most intuitive ER diagram styles.

Features of ER-Model

The main features of the model are as follows:

MySQL world database ER Diagram

In this example, we will use the MySQL world database. The database consists of three tables.

MySQL Tutorials

MySQL Tutorials on this website:


Exit mobile version