Know any good database diagramming tools?

bdi · Nobody Joined: 21 Oct 2004 Posts: 1646 Location: Chicago

If you know of any good database diagramming tools, post them here for others to try!

NOTE: This thread is for reference use, please be sure to include the name of the product you are recommending, and a link to the site where information can be found about it.

Programmer's Corner - .NET, Web Development, SQL, C++, and more.
Visual Basic Explorer - For all your Visual Basic 6 needs!

Edited by: BeadyEye at: 7/24/03 9:12 am

aschenta

MS Visio and their ERD

Basically any UML program that has an ERD available in it (especially the cheap ones

)

Programmer's Corner - .NET, Web Development, SQL, C++, and more.

Edited by: *narf* at: 7/24/03 10:07 am

DNAunion2000@ · Ronin Joined: 05 Jul 2003 Posts: 31

DNAunion: I didn't see much ERD in Visio's ERD. I didn't see relationships, just lines. I didn't see numbers representing cardinality or multiplicity. I didn't see any composite entities. I didn't see any weak entities. I didn't see any generalizations.

Also, ERD and UML are not the same. The closest that UML comes to an ERD is their class diagram with the classes using a <<persistent>> stereotype (IIRC). They also represent relationships differently, cardinality and multiplicitly differently, combined table-and-relationship differently (composite entities in ERD and association classes in UML), and so on. One diagram's components can be mapped to the other, but so can a Visual Basic program's code be mapped to C++.