I have a homework that I wanna present neatly.
All commercial software.
Core Xii
2010-10-31 13:31:21
Did you downvote this, Core Xii? The OP did not ask for free software. Although a student is unlikely to buy any of these, s/he might check for them in his/her school's software library.
larsmans
2010-10-31 13:35:01
A:
Yes you can do this with Dia and use the ER Shapes. Than you can use "er2sql", I wrote, which generates all the sql statements for the tables with attributes, keys and foreign keys. http://sourceforge.net/projects/er2sql/
vurte
2010-10-31 13:23:41
+2
A:
If you're in the Visual Studio usage; you can use Entity Framework and print out the model it generates.
There's also Enterprise Architect, which is a bit of an overkill imho.
Serg
2010-10-31 13:30:08
I love GraphViz, but I wouldn't recommend it for E/R diagrams as my first thought.
duffymo
2010-10-31 14:19:22
+2
A:
You can use MySQL Workbench 5.0. It'll create nice E/R diagrams, as long as you're able to ignore the MySQL slant to things.
duffymo
2010-10-31 14:18:55
+1
A:
I think simplicity is the key here, not a programming language that must be learned, just to produce an Entity Relation Diagram. Also, you've asked for ERDs which are really simple (Entities, Relations only), and many here are proposing tools required to build a full full Data Model (columns, plus plus).
Any simple drawing tool will do for ERDs. OmniGraffle rocks on Apples (which more and more students have nowadays, at least in the developing world), and for which there are some great stencils (heh, heh); Visio or ABCFlowCharter if your machine is a Piece of Crap.
PerformanceDBA
2010-10-31 15:22:58