Re: A Simple Analysis?
From: Dan Wu <danwu_at_cs.uregina.ca>
Date: 2000/05/29
Message-ID: <Pine.SGI.3.91.1000529001415.20000A-100000_at_ARISTOTLE.CS.UREGINA.CA>#1/1
Date: 2000/05/29
Message-ID: <Pine.SGI.3.91.1000529001415.20000A-100000_at_ARISTOTLE.CS.UREGINA.CA>#1/1
> Case 3
> ------
> A B C
> 0 0 0
> 0 1 1
> 1 0 2
> 1 1 2
>
> ??? Here it appears that A partitions all the possible values for C.
> What kind of dependency is here and how (if at all) should it
> be decomposed?
Hi,
It seems we have a MVD in your Case 3, it is
A->->B|C. Once you admit it is a MVD, it is easy to
decompose your case 3 as follows,
r(ABC)=r(AB) njoin r(AC).
Dan Received on Mon May 29 2000 - 00:00:00 CEST