Posted by AlterEgo on 01/19/07 19:11

fireball,

It looks to me like your model is defining a 1:n structure, not 1:1.

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

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

ChildTable data example
--------------
ChildID, ParentID
1, 100
2, 100
3, 100

In this scenario, you can have one Parent (100) for many Children (1,2,3).
To implement this physically, just make sure you have a ParentID column in
the ChildTable that references the ParentTable.

Is that the question you were asking?

-- Bill

"fireball" <fireball@onet.kropka.eu> wrote in message
news:eoqnag$3ka$1@nemesis.news.tpi.pl...
> 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.
>
>

[Back to original message]