Logical and physical data models

[michielper]

To what extend does Sparx EA support the relationship between a logical and a physical data model? Let me explain:
I know that you can very wel create a logical data model in EA, e.g. as a class diagram. But...

• does EA also let you define a physical data model for a relational database in which tables, attributes and cardinalities are exactly specified and....
  
• Can it generate the Create Table statements from this model?
• How does EA guard the relationship between the logical and physical model? How are changes in one propagated to the other, etc.?
  
• Is it wise to use EA for this purpose or is it better to use a specialised database-design tool?

Thanks in advance for your shared insights!

[Richard Freggi]

Yes
Yes (for supported DBMS only)
Just most basic and straightforward generation of physical data model from logical (you may need to manually change the physical data model to your taste, that's not necessarily a bad thing I would not blindly trust a tool to make all DDL decisions for me)
No (a dedicated data modeling tool is better; EA is a UML tool with bolted - on data modeling as an afterthought / freebie, and I have no issue with that: EA is sold as an enterprise architecture tool not a dedicated data modeling tool)