After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 57386 - Enhancement Request: Better ER diagrams
Enhancement Request: Better ER diagrams
Status: VERIFIED INCOMPLETE
Product: dia
Classification: Other
Component: general
0.88.x
Other Linux
: Normal enhancement
: ---
Assigned To: Dia maintainers
Dia maintainers
Depends on:
Blocks:
 
 
Reported: 2001-07-11 14:08 UTC by Michael Tiemann
Modified: 2009-08-15 18:40 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Michael Tiemann 2001-07-11 14:08:06 UTC
The ER diagrams of dia don't match the ER diagrams I've seen in textbooks
(and which seem much better).  The diagrams I'm thinking of have lines with
interesting connectors (small forks, bubbles, etc) to reflect many-to-one,
one-to-one, nullable, etc., relationships between entities.  I've enclosed
the following attempt at ascii art to show you:

-------      -------
|     |\     |     |
| emp |----o-| org |
|     |/     |     |
-------      -------

This diagram says that there's a many-to-one relationship between employees
and organizations, and that every employee must belong to some
organization, but that some organizations might have no employees.

Is anybody familiar with this kind of diagram?

M
Comment 1 Steffen Macke 2001-08-18 05:33:24 UTC
The bubble is already there, if you use a normal zigzagline and
select the proper arrowtype. The fork is still a problem.

Is there some online documentation with a kind of standard for these
things?
Comment 2 James Henstridge 2002-05-02 01:25:43 UTC
Mass reassign of bugs to dia-maint@bugzilla.gnome.org.
Comment 3 Cyrille Chépélov 2002-09-25 18:04:04 UTC
Indeed, in "J2EE 3rd Ed" from O'Reilly, there are plenty of very nice
ER diagrams with the thing you rendered in ASCII above.

Now that it's less painful to add an arrow type, it may be useful to
spot what's in this book, and add at least these.
Comment 4 Demian Wassermann 2003-06-03 19:42:17 UTC
The ER diagram that you're asking for is just another ER notation. I 
think opinion the notation used in DIA is more descriptive. In fact 
there are several ER flavors.

If you're looking for textbooks in "Fundamentals of the database 
systems" by Elmasri and Navathe the current notation is used.



Comment 5 Lars Clausen 2004-02-23 12:49:00 UTC
Crow's foot arrow has been added, as well as several other interesting
arrows.  If you can point us at an online picture, or attach one, we
can look at what else is desired.
Comment 6 Marius Andreiana 2004-12-07 07:49:35 UTC
I have that book (3rd edition). Looking at pages 97 and 319, there 2 ER
diagrams, but both can be done in current Dia.

If dia developers agree, I propose to close this.
Comment 7 Hans Breuer 2004-12-07 08:09:40 UTC
I don't have the book but like closing bugs :-)