At 09:32 PM 20/11/2003 +1100, Alan McDonald wrote:

> > >If TBL_PERSON and TBL_PARTY share the same PK - why don't you
> > just have the
> > >fields in TBL_PARTY to the TBL_PERSON table.
> >
> > :))) Because I have a TBL_COMPANY as well.
> >
> > --
> > Best regards,
> > Alexander mailto:saho@...
>
>If it's the same thing then I would argue the same ting again..
>You don't win anything in terms of storage, or speed or efficiency by
>separating fields across tables when they all share the same PK.
>Use FK logic for where it applies - i.e. many records for a single
>master/parent

I totally disagree. There are good reasons to split up large entities into
a master entity and spin off a number of optional 1:1 relations. This
avoids storing "places" in a main table that will never be used. This is
relational database we are dealing with here, not spreadsheets.

heLen