In Astah Professional, you can easily convert your UML models to ER models.
You can convert your UML Class diagram into the ER diagram with one-click.
Any composition relationships will be converted 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.
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.
UML Class’s attributes’ will be converted to ER Entity’s data type as shown in the table below.
UML Attribute type
|boolean, bool, System.Boolean||BIT|
|long long, char, unsigned long long, wchar, octet, sequence,|
wstring, object, signed char, unsigned char, wchar_t
|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,
|java.sql.Date, java.util.Date, System.DateTime||DATE|
|double, long double, System.Double||DOUBLE PRECISION|
|string, System.String, java.lang.String||VERCHAR|
In Astah Professional, you can convert all UML models in a project file to ER models at once.