Posted by fireball on 01/22/07 10:06

Bill thx for your time!

Your example looks like aggregation 1:many, that's correct - but the problem
is I need to create _strong_ aggregation (=composition) 1:many,
distinguishing from simple (weak) aggregation, your example seem to realize:

So I created two relations in my Rose:
a) aggregation (empty diamond) 1..*
b) composition (filled diamond( 1..*
and then I transformed it to data mode: And what I got?

a)
ParentTable
------------
ParentID (PK)

ChildTable
------------
ChildID (PK)
ParentID (FK)

b)
ParentTable
------------
ParentID (PK)

ChildTable
------------
ParentID (PFK)

which means for me 1:1, (and telling the truth, looks like
generalization/specialization - am I correct or not?)



TIA for further discussion

[Back to original message]