8

I have started to study ER diagrams. When I browse through the ER diagram tutorials, I found something like figure 1:

Figure 1

enter image description here

I tried to create a sample ER Diagram in MySQL Workbench like:

Figure 2

enter image description here

I browsed Google images for ER Diagrams, and I saw both types of images. I don't know the similarities and differences between them.

1
  • 1
    When I had this question come up, I discovered that the "standard" is "Chen like". That is, there is no standard but there are loose conventions that products more or less follow at their whim. To make things more confusing, ERD's don't express how entity relationships change over time, capture inheritance that is so critical to modern object oriented systems, or capture the "becomes" concept. I much prefer UML diagrams, which capture everything an ERD does but also caaptures these other concepts.
    – pojo-guy
    Commented May 12, 2016 at 4:34

3 Answers 3

11

One can say that a proper entity-relationship diagram is that which was created using the constructs introduced by Dr. P. P. Chen (e.g., rectangular and diamond-shaped boxes) in his famous 1976 paper entitled The Entity-Relationship Model—Toward a Unified View of Data.

Regarding your specific comparison, Figure 1 displays symbols (perhaps shapes) that look much closer to the Chen’s originals than the ones shown in Figure 2.

Pertinent considerations

But, if a certain drawing portrays (a) entity types, and (b) the corresponding entity types interrelationships, then it can be considered some kind of entity-relationship representation (and multiple methods are associated in a certain way with the work of Dr. Chen).

In this respect, IDEF1X is a data modeling technique —established as a standard in 1993 by the U.S. National Institute of Standards and Technology (NIST)— that takes Dr. E. F. Codd’s relational concepts (e.g., foreign keys and alternate keys) and combines them with entity-relationship ideas and first-order logic elements in order to assist in the composition of more rich and expressive diagrams (which can, e.g., depict supertype-subtype associations, entity type properties or attributes, etc.).

There are other efforts that produced, e.g., the enhanced entity-relationship approach, which also added new notions to the original view.

These paradigms (some more complete than the others) are platforms that were developed to capture business-domain-specific data meaning (i.e., data semantics). With their help, a practitioner can supply communication instruments that facilitate managing the data as it actually is, i.e., an important and independent asset, presenting the scenario of interest from a conceptual perspective (sometimes incorporating logical level aspects) to all the involved parties.

Asides

Concerning some aside comments, it must be said that (i) application program components are different from (ii) database structures, therefore they definitely hold different implications. In this manner, you can use “general” implements like UML sketches to shape object-oriented application program items, e.g., classes (basically, object templates), methods (i.e., object processes, behaviour), etc. In addition, application program components are part of the external level of a computerized information system, so any kind of sketch depicting them should not necessarily have a one-to-one correspondence with a diagram illustrating structures of the conceptual level.

That being so, and since software development is a profession that entails accuracy, identifying and employing the right tool for each clearly delimited task is paramount.

7

The first one is traditional Chen's notation.

The second one is modern Crow Foot or Baker's notation, used today by majority of tools and people. It is perferred because it is more readable and uses less space.

2

The first is an ER-Diagram (Entity Relationship Diagram).

The second is an EA Diagram (Entity Attribute Diagram).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.