Re: Hospital ERD

"Mike Sherrill" <MSherrillnonono_at_compuserve.com> wrote in message news:lab42010rb2tbf1m5d04100if8q1o83ld4_at_4ax.com...
> On Wed, 4 Feb 2004 20:12:50 +1000, "Peter Mount"
> <info_at_petermount.au.com> wrote:
>
> >The theory being it's best to keep related data in only one table
>
> It's best to keep related data in related tables.

Unless......the related data is not functionally determined by the entity (key) , or unless we want to avoid the use of nulls and there exists some uncertainty as to values at certain times, or unless the data is only indirectly functionally determined by the entity (key), etc., etc.

• Dan
  >
  > --
  > Mike Sherrill
  > Information Management Systems