The great tool I'm using in everyday work, with great support for diagrams (SQL Server, Oracle, MySQL) is DatabaseSpy from Altova. Take a look at http://www.altova.com/databasespy.html