A good CASE TOOL program
last night I had to draw some database diagrams (some ERDs and DFDs) for my boss and beleive me it's too hard to do it in Dia, the only tool that I know. Don't we have something in Linux that I can define my database fields + their relations in it and then it can draw me the whole diagram?? I use MySQL and I know you can do it with phpMyAdmin, but what it makes isn't that nice, I mean it gives ya a PDF file with some tables that's not really clear (the relationships mostly)
I know that there used to ba a plugin for Eclipse where you could build MySQL models, with relations and so on.
Then there is a bunch of comercial products that are presentated at MySQL official Site