There are a ton of half-finished or half-complete open source data modeling software projects out there. I've just been evaluating them for a client. At the moment, Power*Architect seems the best for my needs:
- open source
- multi-platform - Java in this case
- multi-database support - I need PostgreSQL and Oracle
- pdf export of ER diagram
- alive and not abandonware
And to top it off, it's actually easy to use! Take that, ERwin. To be fair, it doesn't have all the features of ERwin, but that's OK for me.