I've always found ERWin to be a good modeling tool, though it is moderately pricey. I had a coworker who swore by Sybase's PowerDesigner.

Rob