• Software
  • ER Diagram Tool for Database Design

Hello everyone, I am working on the analysis of a database driven app, and I need to present the EER diagram as part of the project report. I already designed the database and I drew the diagram on paper but now I want to draw it using some tool so that it looks better and more tidy. I follow a combination of Chen's (for entities and attributes and relations) and Crow's Foot(for cardinalities) notation for drawing ER diagrams especially for presentation purposes because it would be more understandable by non-technical people unlike the other kinds of notations, as I will be including a more technical diagram too.

My problem here is that I couldn't find the right tool for drawing ER diagrams with this kind of notation as in MS Visio it is drawn using another notation that I don't want. I tried other tools like Concept Draw Pro and other tools, they are good but there are lots of missing features and icons I need such as the notations for mutli-valued attributes, super/subtypes, weak entities, associative entities and also many cardinalities etc... are not present. The best tool among them was Gliffy which has (almost) all what I want from symbols but the problem is that everything is in black and white and I would like to give some colors for the different symbols in the diagrams.

Here is an example of the different symbols and cardinalities that I would like to include in my diagram:



I got the image from an old book which does not ptovide any reference of the tool used, I have the new edition of the same book and the diagrams are drawn using MS Visio in another notation that I don't want to use.

So if you know of any tool that will help me get the job done or if you have any comments, ideas, and thoughts please share. Thank you very much for your help and comments.

P.S. I will be using Photoshop or GIMP to get the job done in the worst case but it will take more time and effort.

EDIT: it's "Tools" not "Toole" in the title, sorry for the typo
I dont know if it has what you need, but MySql Workbench (provided on the MySql website) has some sort of diagram creation facility to it. I dont know if it has the ones you need though.
Worst case scenario you can generate them in Gliffy then colour them using the bucket tool in photoshop.