The Entity Relationship Diagrammer shows tables and their relationships to each other systematically, following the IDEF1X standard. ER Diagrammer can create an entity-relationship diagram from an existing database.
Optionally, for a complex database, ER Diagrammer can generate diagrams for the portions that you specify. Usually, the result will picture the tables in a manner that clearly shows all relationships, with parent tables always to the left. If you prefer, you can rearrange the tables differently, and the connectors will follow along. The graphic can then be saved in a file for future display.
A Sophisticated Design Tool
You can also use ER Diagrammer in conjunction with Hora to generate a data model for a new database. Simply use Hora to define tables—adding, dropping and renaming columns where necessary; then use ER Diagrammer to create a graphic view of your data model.