CODEWITHSUNDEEP
databasedatabase-designdiagramerder-diagram
PeakGen
PeakGen

Reputation: 22995

What is the "Real" ER Diagram?

I am not that much good at database diagraming. Whenever I am asked to create an ERR Diagram, I use MySQL WorkBench software.

However today I ended up in a conclusion when I see different types of ER Diagrams. My diagrams (designed via MySQL WorkBench) are like below.

enter image description here

And I saw other types of ER Diagrams like below.

enter image description here

Can someone please confirm which ER Diagram model should I use?

Upvotes: 2

Views: 1822

Answers (2)

DrabJay
DrabJay

Reputation: 3099

An Entity Relationship Diagram is an example of a presentation of a Conceptual Model. A Conceptual Model is used to help people understand the subject area(s) the model represents. Therefore, the correct presentation of a Conceptual Model - which may be or include an Entity Relationship Diagram - is one that all interested parties are satisfied adequately explains these subject areas. These interested parties should include potential users of a system that incorporates the subject areas, managers of these areas and IT professionals who will be designing and building a system covering these areas.

The agreed Conceptual Model is then taken by the IT professionals and formalized into a Logical Model, which may be presented as a Relational Data Model.

Upvotes: 3

boddza
boddza

Reputation: 11

Actually both of them are ER diagrams. However, the second one is its scientific representation. MySQL use a representation which is more understandable way of it.

Upvotes: 1

Related Questions