Re: Why spurious tuples with fifth normal form?

From: Tony Andrews <andrewst_at_onetel.com>
Date: 15 Jun 2005 13:14:11 -0700
Message-ID: <1118866450.991816.312800_at_g43g2000cwa.googlegroups.com>


stowellt_at_gmail.com wrote:
> Hello All,
>
> I have spent countless hours searching the net to find the answer, but
> am still confused. I have a db structure where I have decomposed a
> table into three smaller tables, but when I join them all back
> together, I get spurious tuples. Now I thought that the whole point of
> fifth normal form was to allow you to successfully decompose a table
> into smaller tables, then join them back together without spurious
> results. Do I have the wrong idea about this, or if not, what am I
> doing wrong? Thanks.

Maybe you decomposed it wrong? Difficult to say based on the information you have given so far (i.e. none!) Received on Wed Jun 15 2005 - 22:14:11 CEST

Original text of this message