UML class diagram and ER diagram share the ability to define a domain model. Software Ideas Modeler allows you to convert the classes to entities, associations to relationships and the class attributes to ERD attributes.
Chen's notation of the entity-relationship diagram depicts data and domain models using entities, attributes, and relationships. Unlike other ER diagram notations, it shows attributes as standalone boxes, not as a part of entities.
The entity-relationship diagram can be turned into a SQL script. The ERD tool can generate create scripts for each entity and relationship in the diagram or only for the selected part. You can transform ERD entities to database tables very easily.
The ERD tool allows you to generate an ER diagram from a SQL database. It is also possible to create an ERD from a SQL DDL script. You can turn the whole schema into a diagram or you can select only some tables that you want to be imported.
If you want to design a data model for your database, you should use an entity-relationship diagram (also known by ERD acronym). It may be used for conceptual, logical, and also physical data models. Alternatively, you may also use a UML class diagram for the same purpose.
There are multiple options how you can join rows of two entities into a single result set. It depends on whether you want to have all data from left entity, right entity, both entities or you want to get common data.
The type set is set to UML by default. When creating data models using E-R diagrams you may want to use another type set - e.g. database-specific.
A primary key uniquely identifies a tuple/row of entity (data set, table). It may be an attribute or a set of attributes. Primary key attributes are marked with + symbol, alternatively with PK acronym or a key icon.
The ERD tool provides many useful features to help you work with diagrams. One of them is the highlighting of the context parts in the diagram.
Using Smart Parser sidebar, you may easily convert SQL scripts to entity relationship diagrams.