Andrus Adamchik <andru..bjectstyle.org> wrote:
> And of course my approach will not work if a single parent can have more
> than one detail record (of same or different kinds).
>
> In other words, is there a valid case when a person.person_id can resolve
> to two or more employee.employee_id's?
I don't think so.
It is my understanding that a single person could resolve only to zero or
one employee.
However, a person_id could have an internal_customer and customer id.
Or an employee and manager id.
Or just an employee id or just a customer id.
Or even a important_internal_customer, internal_customer, and customer id.
Or to put it another way, a given parent entity never has more than one
child at each level of the inheritance.
-Mike
This archive was generated by hypermail 2.0.0 : Fri Jun 17 2005 - 16:53:15 EDT