DBdesigner is a great tool for designing Database schema, generating the SQL associated, and editing beautiful database schema images so that you’re proud and happy to show your design to your fellow developer friends.
We will use WINE which is a windows emulator, and we will run the windows version of DBDesigner.
We do that instead of using the linux version, simply because it works MUCH better than using the Linux version :-)

- Install Wine
yum install wine #under debian for example
apt-get install wine #under ubuntu kubuntu for example

- Download DBDesigner on http://fabforce.net/dbdesigner4/downloads.php

- install DBDesigner
wine DBDesigner4.0.5.6_Setup.exe

- execute DBDesigner (create a shortcut to it on the desktop for example)
wine ~/.wine/drive_c/Program\ Files/fabFORCE/DBDesigner4.exe

- Have fun designing beautifully engineered databases :-)