LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices



Reply
 
Search this Thread
Old 04-12-2004, 12:09 PM   #1
jrbiochem
Member
 
Registered: Apr 2004
Location: Dundee, Scotland
Distribution: Fedora Core 2
Posts: 57

Rep: Reputation: 15
Question 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
 
Old 04-12-2004, 04:27 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,004
Blog Entries: 11

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


Cheers,
Tink
 
Old 04-12-2004, 04:55 PM   #3
Crito
Senior Member
 
Registered: Nov 2003
Location: Knoxville, TN
Distribution: Kubuntu 9.04
Posts: 1,168

Rep: Reputation: 53
CASE Studio works with just about every DBMS: http://www.casestudio.com/
 
Old 04-12-2004, 06:39 PM   #4
jrbiochem
Member
 
Registered: Apr 2004
Location: Dundee, Scotland
Distribution: Fedora Core 2
Posts: 57

Original Poster
Rep: Reputation: 15
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
 
Old 04-13-2004, 03:17 PM   #5
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,004
Blog Entries: 11

Rep: Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903
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
 
Old 04-13-2004, 04:58 PM   #6
jrbiochem
Member
 
Registered: Apr 2004
Location: Dundee, Scotland
Distribution: Fedora Core 2
Posts: 57

Original Poster
Rep: Reputation: 15
cheers Tink, appreciate the help.

J
 
Old 04-14-2004, 03:46 PM   #7
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,004
Blog Entries: 11

Rep: Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903
Does it work for you, or are the UML shapes
unacceptable for your needs?


Cheers,
Tink
 
Old 04-14-2004, 03:54 PM   #8
jrbiochem
Member
 
Registered: Apr 2004
Location: Dundee, Scotland
Distribution: Fedora Core 2
Posts: 57

Original Poster
Rep: Reputation: 15
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
 
Old 04-14-2004, 04:05 PM   #9
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,004
Blog Entries: 11

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


Cheers,
Tink
 
Old 04-14-2004, 04:12 PM   #10
jrbiochem
Member
 
Registered: Apr 2004
Location: Dundee, Scotland
Distribution: Fedora Core 2
Posts: 57

Original Poster
Rep: Reputation: 15
That's really not too bad actually- my student budget may be able to stretch that far.......

Thanks for the pointer!


J
 
Old 04-14-2004, 05:44 PM   #11
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,004
Blog Entries: 11

Rep: Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903Reputation: 903
Glad it's taking your fancy :}

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


Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Software for creating diagrams? brynjarh Linux - Software 4 09-28-2005 02:39 PM
Searching for geometric (simple) drawing software sfingerh Linux - Software 3 01-02-2005 08:39 PM
ASCII Diagrams? baldy3105 LQ Suggestions & Feedback 7 03-28-2003 10:31 PM
Map drawing software Citizen Bleys Linux - General 1 02-13-2002 04:01 PM
Vector Drawing & Publishing Software PuterFreaK Linux - General 3 12-22-2001 02:58 PM


All times are GMT -5. The time now is 05:09 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration