I'm looking for free tool for generating ER diagram. I now there are a lot of stuff I can find them in google, but I need something specific and can't it find.
The tool should generate ER diagrams showing relations between attributes like in below image. Note that this diagram shows phisical relation table1.attributeX <----> table2.attributeY
Note: I am not asking for tools that generate diagrams like these. This diagrams doesn't explicit show relations between attrobutes.
(source: philblock.info)
SchemaCrawler is a free tool that generates diagrams showing relations between attributes. That is, there is a relationship line drawn from the primary key column to the foreign key column. Here is an example diagram:
Sualeh Fatehi, SchemaCrawler