Most of the time, I used Microsoft Visio to draw all the diagrams. Whether it is UML, flow chart, use case, database, Visio is the standard tool for me. Quite often, I had to come up with the database design and always looking for a tool which can connect with the SQL Server/SQL Azure and prepare the model for me. Needless to say, Visio has the feature. Using Visio database model explorer, one can connect to the database to bring up the model and send the modification back to the database, if done.
Here is the link to download the Data Model Explorer and get started with the reverse engineering feature.