Aggregation relationship

[Maja Vasilijeva]

Hi,

I would like to use aggregation or composition relationship in Data Model.
It works fine on the domain level so if generate java or c# code for an aggregate class all aggregated classes are included.
On data level I would like to get column/attribute of aggregated class as a column/attribute of the aggregate so I can generate DDL
Is this possible ?

[Sunshine]

Not sure why you want to enhance the datamodel with aggregation and composition. As I understand it the Data Model diagrams don't have the concept of aggregation or composition. In UML when the PIM is transformed using the DDL it translates these as simple associations with primary and foreign keys. You could modify the DDL transformation to preserve the aggregation/composition so you get it in the DDL model but you'll probably have issues when generating the DDL script to create the database.
So yes it is possible but why? [smiley=huh.gif]

[Maja Vasilijeva]

The answer is pretty simple - I am lazy  

I already defined types, lenghts etc. of aggregates on all columns in Data Model/attributes in classes and as on DB level  I needed one table to hold them all I hoped I could use aggregation in data model, create DDL and create the table.
I found the why to create the table I wanted --> Copy Paste from DDL's of aggregates in a script under table name I wanted.

Thanks anyway