Subject RE: Re[2]: [firebird-support] Primary Key, Foreign Key
Author Alan McDonald
> 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

And if all these spin-off fields are frequently used, what advantage is
there?
I'm sure some design statements need to be issued before one can conclude
one way or the other as better design.
Alan