Posted by fireball on 01/19/07 15:08

hi, I got confused for a moment about creating data structure for UML
composition (strong aggregation) relation one-to-many.

I used Rose/DataModeler to do so.
[Parent] <filled_diamond>-------- [Child]

I got P/FK (primary key of my component is foreign key of it's container) in
my child table:

Parent: PK Parent_ID
Child: P/FK Parent_ID

that way I found out I got relation 1:1, I'm still not sure how to create
data structure realizing compositiona one-to-many.

• Next in forum: Re: Is this query possible?
• Prev in forum: Re: SQL Statement to return first unique record
• Thread view: sql code for UML composition relation - anyone?

[Reply to this message]