Convert UML to ER
In Astah Professional, you can easily convert your UML models to ER models.
Convert Class diagram to ER diagram
You can convert your UML Class diagram into the ER diagram with one-click.
- Select [Convert to ER Diagram] from the Class diagram’s pop-up menu in the tree view.
- Now the ER diagram will be created and appears in the tree.
Convert rules
Compositions to Identifying Relationship
Any composition relationships will be converted to Identifying-Relationship.
Associations to Identifying relationship
In order to convert association to Identifying relationship, Add “identifying” stereotype to the association and let it have “one-to-many” multiplicity.
Associations to Non-Identifying Relationship
In order to convert an association to a Non-Identifying relationship, add “Non-identifying” stereotype to the association and let it have “one-to-many” multiplicity.
Data Type
UML Class’s attributes’ will be converted to ER Entity’s data type as shown in the table below.
UML Attribute type | Convert to |
|---|---|
| boolean, bool, System.Boolean | BIT |
| long long, char, unsigned long long, wchar, octet, sequence, wstring, object, signed char, unsigned char, wchar_t | CHAR |
| byte, int, long, short, sbyte, uint, ulong, ushort, unsigned short, short int, signed short int, unsigned short int, signed int, unsigned int, unsigned long, long int, signed long int, unsigned long int, System.Byte | INT |
| java.sql.Date, java.util.Date, System.DateTime | DATE |
| double, long double, System.Double | DOUBLE PRECISION |
| float | FLOAT |
| decimal, System.Decimal | DECIMAL |
| string, System.String, java.lang.String | VERCHAR |
Convert UML to ERD
In Astah Professional, you can convert all UML models in a project file to ER models at once.
- Go to [Tools] – [ER Diagram] – [Convert UML Model to ER Model].
- Select which UML models to convert to ER models and click [OK].
