Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Why spurious tuples with fifth normal form?

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@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 - 15:14:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US