LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (http://www.linuxquestions.org/questions/linux-general-1/)
-   -   Software for drawing entity-relation diagrams with tables (http://www.linuxquestions.org/questions/linux-general-1/software-for-drawing-entity-relation-diagrams-with-tables-169164/)

jrbiochem 04-12-2004 11:09 AM

Software for drawing entity-relation diagrams with tables
 
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

Tinkster 04-12-2004 03:27 PM

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


Cheers,
Tink

Crito 04-12-2004 03:55 PM

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

jrbiochem 04-12-2004 05:39 PM

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

Tinkster 04-13-2004 02:17 PM

Quote:

Originally posted by jrbiochem
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?
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

jrbiochem 04-13-2004 03:58 PM

cheers Tink, appreciate the help.

J

Tinkster 04-14-2004 02:46 PM

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


Cheers,
Tink

jrbiochem 04-14-2004 02:54 PM

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

Tinkster 04-14-2004 03:05 PM

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


Cheers,
Tink

jrbiochem 04-14-2004 03:12 PM

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

Thanks for the pointer!
:D

J

Tinkster 04-14-2004 04:44 PM

Glad it's taking your fancy :}

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


Cheers,
Tink


All times are GMT -5. The time now is 11:26 PM.