Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is ERD considered a kind of UML diagram?

Tags:

uml

erd

Are Entity Relationship Diagrams(ERD's) considered a type of UML diagram or are they a separate thing?

like image 513
mts396 Avatar asked Jan 10 '18 15:01

mts396


People also ask

Is UML same as ERD?

What is the difference between UML and ERD? The main difference between UML and ER diagrams is that UML is a language used to create diagrams, whereas ERDs are a type of diagram. UML is used for planning software development, and is used in many different diagrams for various purposes.

What type of diagram is ERD?

Entity Relationship Diagram, also known as ERD, ER Diagram or ER model, is a type of structural diagram for use in database design. An ERD contains different symbols and connectors that visualize two important information: The major entities within the system scope, and the inter-relationships among these entities.


3 Answers

I have another idea. I think we should look in-depth.

When we are talking about ERD (Entity Relationship Diagram), we are talking about Entity Relationship Modeling.

It is firstly introduced by Peter Chen (1976). He has two famous articles on Entity Relationship Modeling (see first and second articles)

He talked about Entity-Relationship Modeling (not Entity-Relationship Diagram). It is ER Model.

There is another paper in 1975 about Modeling the Real World System.

ER Modeling is (see reference, the second paragraph):

In software engineering an ER model is commonly formed to represent things that a business needs to remember in order to perform business processes. Consequently, the ER model becomes an abstract data model that defines a data or information structure that can be implemented in a database, typically a relational database.


Diagramming Convention Techniques

When we are talking about ER Modeling, there many diagramming convention techniques.

  1. Chen Notation (some links need translation)
  2. IDEF1X Notation
  3. Bechman Notation
  4. Martin notation
  5. (min, max)-notation of Jean-Raymond Abrial in 1974
  6. UML class diagrams

And other notations (see reference)

enter image description here

All of above notations are using for ER Modeling or Data Modeling.

There is no earth-shattering difference between UML notation and other ER notations. They all model the most important elements of data models.

Finally: UML is a set of standard graphical tools to model the whole or parts of a project. We can use UML (Class Diagram) for ER Modeling and name them our ER Models or ERDs. So we can say: this is my ERD in UML Notation.

like image 118
Gholamali-Irani Avatar answered Oct 07 '22 17:10

Gholamali-Irani


ERD is it's own thing. It's not in UML specification. You can download specification PDF from the link.

UML is a common notation/language for object oriented modeling and it includes a multitude of diagram types. ERD is a diagram for data modeling (attributes and relationships). Some structural UML diagrams are fairly similar in what you can model, but the concept is different.

Types of UML diagrams:

Types of UML diagrams

like image 41
Justinas Marozas Avatar answered Oct 07 '22 19:10

Justinas Marozas


This was the first search on Google:

Key Difference: UML stands for Unified Modeling Language. ERD stands for Entity Relationship Diagram. UML is a popular and standardized modeling language that is primarily used for object oriented softwares. Entity-Relationship diagrams are used in structured analysis and conceptual modeling

like image 22
Kieran Avatar answered Oct 07 '22 17:10

Kieran