Hi!

I'm designing a database for MySQL for my Masters Thesis. I need to draw an entity-relation diagram with tables as the entities. I know it can be done- I've seen an example from my department (my tutors currently away).

Dia/Vsio are not really what I'm looking for- I need the tables. Does anyone know of any useful (and free) Linux-based software for this?

Thanks,

Jon

You may want to look at dia (and add-ons/plug-ins)
again ... http://www.lysator.liu.se/~alla/dia/links.html


Cheers,
Tink

CASE Studio works with just about every DBMS: http://www.casestudio.com/

Thanks for the help.

Tink: Could you point me in the right direction with dia? I've had a look, and the only table-type objects are UML, not really what I'm after. I need something which can represent the cardinalities and with text-sensitive tables. What am I missing? Could you suggest some useful modules, and where to get them from?

Crito- Thanks for the pointer, that seems exactly what I need, but don't really think I can afford the license for Case Studio, and need a more permanent solution than the trial (I'm assuming it dies after a couple of days.....). Any other ideas?

Cheers,

J

Sure .. have a look at this one.
http://tedia2sql.tigris.org/

He doesn't use a specific set of diagrams but
rather "normal" UML to describe tables, but it
works. Look at tedia2sql/www/TestERD.dia


Cheers,
Tink

cheers Tink, appreciate the help.

J

Does it work for you, or are the UML shapes
unacceptable for your needs?


Cheers,
Tink

Hi Tink,

The shapes are fine for the design process, and quite handy how tedia2sql can actually write the design to MySQL, but if I can't find anything with proper ERD notation, I'm going to be having a fight with MS Word or something to draw from scratch for my thesis write-up!

In the meantime I'll be keeping my eyes open for a better solution.......

Cheers again,

J

This one is probably too expensive, too, then?
http://www.thekompany.com/products/dataarchitect/


Cheers,
Tink

That's really not too bad actually- my student budget may be able to stretch that far.......

Thanks for the pointer!


J

Glad it's taking your fancy :}

I thought it may be closer to what you need than
the dia solution.


Cheers,
Tink