Help Topics

Entity Relationship Diagram (ERD)

An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. These entities can have attributes that define its properties. By defining the entities, their attributes, and showing the relationships between them, an ER diagram illustrates the logical structure of databases.

Why is Entity Relationship Modeling important?

An entity-relationship diagram (ERD) is crucial to creating a good database design. It is used as a high-level logical data model, which is useful in developing a conceptual design for databases. A relationship is the association that describes the interaction between entities.

What is Entity Relationship model with example?

Entity Relationship Modeling (ER Modeling) is a graphical approach to database design. It uses Entity/Relationship to represent real world objects. An Entity is a thing or object in real world that is distinguishable from surrounding environment. For example each employee of an organization is a separate entity.

What is entity attribute and relationship?

Entities, Relationships, and Attributes. For instance, PERSON denotes the entities of an entity-set with attributes NAME and AGE, while ASSIGNED denotes the relationships between the entities of entity-sets PERSON and PROJECT. Attributes take their values from underlying primitive domains called value-sets.

What is the relationship between the class diagrams in UML and the entity-relationship diagrams?

Class Diagram can be used for modeling the structural view of an object-oriented system, while entity-relationship diagram (ERD) typically models the persistent view for a relational database. See the full article for more details.

Free Pre-Assessment Request

Do you want to know how your competitors are doing business?

Tell us a little about yourself below to gain data for free

Hi What’s your name?


Hi [First Name], what is your company’s name and website?



Is your company looking for any data on the following services:



Gotcha! Do you want to monitor any specific competitor or market?

List of Competitors

  • Add competitor…



Finally, what’s your email address and your phone number?



Your Data is on the Way!

Our data scientists team is working for you by collecting data and we’ll come back to you shortly with a pre-assessment and proposal.

WYgroup BI uses the information you provide to us to contact you about our relevant content, products, and services . You can unsubscribe from communications from HubSpot at any time. For more information, check out WYgroup’s Privacy Notice.