The best CASE tool I've worked with is Enterprise Architect from Sparx .
It's light in weight compared to Rose (easier to buy and cheaper), but extremely powerful. You could make great UML diagrams or a database model or anything else you want, but in a beautiful and organized way.
This helps a lot in the initial stages of the development process, since you could create a domain model, make some preliminary use cases, compare them with the requirements and present all this in a beautiful way for the client. It helps me to think, and I will reorganize my design until I am satisfied to start the proper documentation. It is also very good for database models, since it can very easily reconstruct most databases.
The only (but pretty serious) flaw he has in my eyes is that his documentation generator is, to put it mildly, crap. Obtaining the correct document from it is almost impossible if you do not invest a significant part of the work in templates, and then it will be only OK.
source share