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: Cardinality of relation with empty set of attributes is 1

Re: Cardinality of relation with empty set of attributes is 1

From: Jan Hidders <hidders_at_gmail.com>
Date: 2 Oct 2006 12:56:19 -0700
Message-ID: <1159818979.421828.55970@b28g2000cwb.googlegroups.com>

Aloha Kakuikanu wrote:
> Proof:
> MVFD with empty antecedent, for example
>
> {} -> {X} | {Y,Z}
>
> claims that cardinality of the XYZ relation is the product of
> cardinalities of its projection onto the sets X and YZ of attributes.
>
> Take {X} to be an empty set, then:
> {} -> {} | {X,Y,Z}
> holds trivially. Since projection to the entire set of attributes
> {X,Y,Z} doesn't really change the relation, it follows that the other
> relation in the MVFD decompostition should have cardianlity 1.

Why would that follow? The size of the projection of the empty relation on {} is 0, the size of the empty relation on {X,Y,Z} is also 0. And the product of those sizes is indeed the size of the empty relation.

Received on Mon Oct 02 2006 - 14:56:19 CDT

Original text of this message

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