How to generate Relational Model from UML Class Model?

uml relational-database enterprise-architect relational-model
notGeek picture notGeek · Mar 23, 2011 · Viewed 9.6k times · Source

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

Thanks

Answer

TomO picture TomO · Mar 24, 2011

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!

Related questions

What's the best UML diagramming tool?

I'm trying to choose a tool for creating UML diagrams of all flavours. Usability is a major criteria for me, but I'd still take more power with a steeper learning curve and be happy. Free (as in beer) would be …

Read More
What's is the difference between include and extend in use case diagram?

What is the difference between include and extend in a use case diagram?

Read More
How to generate UML diagrams (especially sequence diagrams) from Java code?

How can I generate UML diagrams (especially sequence diagrams) from existing Java code?

Read More