Tools to draw ER diagrams (tried visio, smartdraw, but didn't work)

database-design er-diagram
Firefox picture Firefox · Sep 19, 2011 · Viewed 8.6k times · Source

I'd like to draw something like below. http://upload.wikimedia.org/wikipedia/commons/7/72/ER_Diagram_MMORPG.png

I've Visio, SmartDraw, MySQL workbench, etc. All of them were missing shapes like double lines, weak entity, identifying relationship (double line diamond box), etc.

I don't find a single tool which has all of them. Please suggest one.

Answer

Patrick Honorez picture Patrick Honorez · Sep 19, 2011

You won't believe it, but I often use plain Excel for diagrams. Nice tutorial here. It works also without their proposed add-in.

Related questions

Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table?

Read More
Database, Table and Column Naming Conventions?

Whenever I design a database, I always wonder if there is a best way of naming an item in my database. Quite often I ask myself the following questions: Should table names be plural? Should column names be singular? Should …

Read More
What's the difference between identifying and non-identifying relationships?

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?

Read More