Simple Database Modeler (SDM) is a Java application that allows to create database models using ER diagrams.
It was mainly written for PostgreSQL database however it has a support even for some other RDBMS.

Main features

Drawbacks

Hints