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: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Fri, 17 Jun 2005 19:15:28 GMT
Message-ID: <kjFse.123632$ti1.6975597@phobos.telenet-ops.be>


Jan Hidders wrote:
>
> To give a small example: let for the relation R(A,B,C,D,E) the candidate
> keys be AB and C, and assume that the JD { ABC, ABE, CE } holds. Is it
> implied?:

Oops. The JD should be (see below) JD {ABC, AB*D*, CE}

> step 1. H = { ABC, ABD, CE }
> step 2. (#1) H = { ABCD, CE } (because ABC and ABC share the c.k. AB)
> step 2. (#2) H = { ABCDE } (because ABCDE and CE share the c.k. C)
> step 3. no more two distinct components with common cand. key
> step 4. The JD is implied by the cand. keys because ABCDE is in H
>
> So even though this join dependency holds, you do not have to split.

Received on Fri Jun 17 2005 - 14:15:28 CDT

Original text of this message

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