Search code examples
umlrelational-databaseenterprise-architectrelational-model

How to generate Relational Model from UML Class Model?

Does anyone know an application (Enterprise Architect, ...) that allows mapping from UML Class Model to Database Relational Model automatically? How?

Thanks

Solution

  • Further to what the others have said, Enterprise Architect supports model transformations from UML class models to Database relational models. It does this automatically.

    To do this, right click on the package that contains your Class Model and select "Transform Current Package" [Ctrl + Shift + H]. Select DDL as your transformation and give it a Target Package (by clicking the [...] button.

    Once you hit the go button Enterprise Architect will perform the translation which will give you the Relationship model. You will now be able to set your desired database language and use Enterprise Archtiect's code generation feature to generate the SQL scrips needed to setup the DB.

    I hope this helps!