Suggest good ERD tool with UML notation
Sparx Enterprise Architect is a UML tool with a database modelling function.  It's not terribly expensive and pretty UML centric.  It also has some pretty good extensibility features if you're that way inclined.