>From Wikipedia:<br><a href="http://en.wikipedia.org/wiki/Entity-relationship_model">http://en.wikipedia.org/wiki/Entity-relationship_model</a><br><h2><span class="mw-headline" id="ER_diagramming_tools">ER diagramming tools</span></h2>
<p>There are many ER diagramming tools. Some free software ER
diagramming tools that can interpret and generate ER models and SQL and
do database analysis are MySQL Workbench (formerly <a href="http://en.wikipedia.org/wiki/DBDesigner" title="DBDesigner" class="mw-redirect">DBDesigner</a>), and <a href="http://en.wikipedia.org/wiki/Open_ModelSphere" title="Open ModelSphere">Open ModelSphere</a> (open-source). A freeware ER tool that can generate database and application layer code (webservices) is the <a href="http://en.wikipedia.org/wiki/RISE_Editor" title="RISE Editor">RISE Editor</a>. The Open Source <a href="http://www.ab.auone-net.jp/%7Esimply/en/works/erviz/about.html" class="external text" rel="nofollow">Erviz</a> takes a simple textual description of the ERD and then uses <a href="http://en.wikipedia.org/wiki/Graphviz" title="Graphviz">Graphviz</a> to automatically produce a layout. The web application <a href="http://tinymodeler.com/" class="external text" rel="nofollow">TinyModeler</a> allows you to make ER diagrams in a web browser.</p>
<p>Some of the proprietary ER diagramming tools are ARIS, <a href="http://en.wikipedia.org/wiki/Avolution" title="Avolution">Avolution</a>, <a href="http://en.wikipedia.org/w/index.php?title=Aqua_Data_Studio&action=edit&redlink=1" class="new" title="Aqua Data Studio (page does not exist)">Aqua Data Studio</a>, <a href="http://en.wikipedia.org/wiki/DbForge_Studio_for_MySQL" title="DbForge Studio for MySQL">dbForge Studio for MySQL</a>, DeZign for Databases, <a href="http://en.wikipedia.org/wiki/ER/Studio" title="ER/Studio">ER/Studio</a>, Devgems Data Modeler, <a href="http://en.wikipedia.org/wiki/CA_ERwin_Data_Modeler" title="CA ERwin Data Modeler">ERwin</a>, <a href="http://en.wikipedia.org/wiki/MEGA_International" title="MEGA International">MEGA International</a>, <a href="http://en.wikipedia.org/wiki/ModelRight" title="ModelRight">ModelRight</a>, OmniGraffle, <a href="http://en.wikipedia.org/wiki/Oracle_Designer" title="Oracle Designer">Oracle Designer</a>, <a href="http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html" class="external text" rel="nofollow">Oracle Data Modeler</a>, PowerDesigner, <a href="http://en.wikipedia.org/wiki/Rational_Rose" title="Rational Rose" class="mw-redirect">Rational Rose</a>, <a href="http://en.wikipedia.org/wiki/Enterprise_Architect_Visual_Modeling_Platform" title="Enterprise Architect Visual Modeling Platform" class="mw-redirect">Sparx Enterprise Architect</a>, <a href="http://en.wikipedia.org/wiki/SQLyog" title="SQLyog">SQLyog</a>, <a href="http://en.wikipedia.org/wiki/System_Architect" title="System Architect" class="mw-redirect">System Architect</a>, <a href="http://en.wikipedia.org/wiki/Toad_Data_Modeler" title="Toad Data Modeler">Toad Data Modeler</a>, <a href="http://en.wikipedia.org/w/index.php?title=SQL_Maestro&action=edit&redlink=1" class="new" title="SQL Maestro (page does not exist)">SQL Maestro</a>, Microsoft Visio, <a href="http://en.wikipedia.org/w/index.php?title=Visible_Analyst&action=edit&redlink=1" class="new" title="Visible Analyst (page does not exist)">Visible Analyst</a>, and <a href="http://en.wikipedia.org/wiki/Visual_Paradigm" title="Visual Paradigm" class="mw-redirect">Visual Paradigm</a>.</p>
<p>Some free software diagram tools just draw the shapes without having
any knowledge of what they mean, nor do they generate SQL. These include
<a href="http://en.wikipedia.org/wiki/YEd" title="YEd">yEd</a>, <a href="http://en.wikipedia.org/wiki/LucidChart" title="LucidChart">LucidChart</a>, <a href="http://en.wikipedia.org/w/index.php?title=Gliffy&action=edit&redlink=1" class="new" title="Gliffy (page does not exist)">Gliffy</a>,<sup id="cite_ref-12" class="reference"><a href="http://en.wikipedia.org/wiki/Entity-relationship_model#cite_note-12"><span>[</span>13<span>]</span></a></sup> <a href="http://en.wikipedia.org/wiki/Kivio" title="Kivio" class="mw-redirect">Kivio</a>, and <a href="http://en.wikipedia.org/wiki/Dia_%28software%29" title="Dia (software)">Dia</a>. DIA diagrams, however, can be translated with tedia2sql.</p>
<br><br><div class="gmail_quote">On Tue, Sep 6, 2011 at 2:28 PM, Michael H. Warfield <span dir="ltr"><<a href="mailto:mhw@wittsend.com">mhw@wittsend.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
On Tue, 2011-09-06 at 13:57 -0400, Pete Hardie wrote:<br>
> Dia?<br>
<br>
That would be one possibility but I've largely given up on Dia down<br>
through the years just for lack of compatibility and import/export with<br>
other applications. Obviously, native Visio compatibility would be<br>
wonderful but, what's there is, errr, primitive at best. Dia does have<br>
the advantage of a nice rich shape library collection and collections<br>
you can add No question there.<br>
<br>
ER Diagrams seem pretty simple, almost akin to flow charts. Those<br>
things could easily be done in just about any 2D CD app like QCad or a<br>
raster graphics package like OpenOffice Draw. I've had to do similar<br>
diagrams for presentation and opted for the later largely because they<br>
were going into either OO Writer or OO Presents. I've reserved using<br>
QCad for doing more architectural type drawings but could easily do the<br>
same in there.<br>
<div class="im"><br>
> On Tue, Sep 6, 2011 at 13:49, David Tomaschik <<a href="mailto:david@systemoverlord.com">david@systemoverlord.com</a>> wrote:<br>
> > Can anyone recommend a good open source tool for drawing ER diagrams?<br>
> ><br>
> > --<br>
> > David Tomaschik, RHCE, LPIC-1<br>
> > System Administrator/Open Source Advocate<br>
> > OpenPGP: 0x5DEA789B<br>
> > <a href="http://systemoverlord.com" target="_blank">http://systemoverlord.com</a><br>
> > <a href="mailto:david@systemoverlord.com">david@systemoverlord.com</a><br>
<br>
</div><div class="im">> --<br>
> Pete Hardie<br>
> --------<br>
> Better Living Through Bitmaps<br>
<br>
</div>Regards.<br>
Mike<br>
<font color="#888888">--<br>
Michael H. Warfield (AI4NB) | <a href="tel:%28770%29%20985-6132" value="+17709856132">(770) 985-6132</a> | mhw@WittsEnd.com<br>
/\/\|=mhw=|\/\/ | <a href="tel:%28678%29%20463-0932" value="+16784630932">(678) 463-0932</a> | <a href="http://www.wittsend.com/mhw/" target="_blank">http://www.wittsend.com/mhw/</a><br>
NIC whois: MHW9 | An optimist believes we live in the best of all<br>
PGP Key: 0x674627FF | possible worlds. A pessimist is sure of it!<br>
</font><br>_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>This Apt Has Super Cow Powers - <a href="http://sourcefreedom.com">http://sourcefreedom.com</a><br>