As its name says, an entity-relationship diagram mainly consists of entities and the relationships between them. You can learn more about conceptual, logical, and physical data models here.Īs I mentioned above, an ER diagram supports all the data modeling levels. In physical data modeling, you develop a complete model that’s ready to implement into the physical database. When you come to the logical level, the entities are expanded to include more details, such as entity attributes. The conceptual level is where you start the initial outline of the data model it’s a very high-level summary of your entire data model. In data modeling, you have to go through three levels: conceptual, logical, and physical.

'Data modeling' is the process of arranging all the related data in an information system graphically, starting from scratch and going step by step through different phases to develop the physical database.

What is data modeling, and how does an entity-relationship diagram (ER diagram or ERD) support it?

In this article, we’ll briefly examine data modeling and which ERD tools best meet database design requirements. As a database professional, the ER diagram should be an essential part of your toolkit.

Ubuntu astah professional