Entity Relationship Diagram Tool
Software Ideas Modeler is an entity-relationship diagram tool which allows you to draw and model a standard ERD diagram or an ERD diagram by Chen notation. You may model entities, relationships, primary and foreign keys and indexes as well.
Free E-R tool
You may draw entity relationship diagrams for free with Software Ideas Modeler Standard (non-commercial usage). Even if you want to use the software for commercial purposes you may buy the software at a very affordable price.
Different Styles for Primary/Foreign Keys and Relationships
Entity Relationship Diagram supports different styles of attribute layout:
You may choose one of three key styles:
- +, #
- PK, FK
- Icons (🔑, ➥)
There are also two possible styles of relationships and their multiplicity:
- Crow's foot
Import from Database
You may import the tables with their relationships from MS SQL, MySQL or any other database which provides OLE DB provider (e.g. Oracle). This E-R diagramming software not only supports the import of new tables, but it may also import the changes. You may choose which tables you wish to add or update and whether you want to generate a diagram or only import tables to the model.
SQL DDL script generation is a must for a good E-R tool and Software Ideas Modeler is no exception. Using it with the change tracking feature, you may also generate change scripts.
Enumerations and Codebooks
Each table in a diagram may contain data directly in the model. This is useful especially for enumerations and codebooks.
Types in E-R Diagrams
You may use the specific database types in your diagrams or you may utilize general UML types and let the software translate to the correct database type.