I use Embarcadero to do data modeling. Today I had to deal with building a database (150+ tables) without a modeling tool... Ummmm and how will this be maintained.... So I started looking for inexpensive data modeling and generation tools... Here's the list:

http://www.databaseanswers.com/modelling_tools.htm
http://www.devarchive.com/u288.html
http://www.devarchive.com/u277.html

More after the Jump

http://www.datanamic.com/dezign/index.html
http://www.dds-pro.com/
http://www.casestudio.com/enu/default.aspx
http://www.contextsoft.com/products/dbdesign/

http://www.fabforce.net/dbdesigner4/
http://www.gurudevelopers.com/products.html
http://www.objectworkshop.com/sanity_data_modeling_features.htm