modelling tools

If you're a Java developer go for ARGO/J-DEVELOPER/MAGICDRAW.
ERWin, OracleDesigner, Visio, QDesigner are still available.

But I'd rather use those open source.