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: Lookup Tables, the right way?

Re: Lookup Tables, the right way?

From: David Cressey <dcressey_at_verizon.net>
Date: Thu, 16 Mar 2006 12:53:32 GMT
Message-ID: <gddSf.1948$%b.272@trndny09>

"Brian Selzer" <brian_at_selzer-software.com> wrote in message news:YXcSf.54315$H71.25427_at_newssvr13.news.prodigy.com...
> > Why do you need "nulls" to represent "missing values"?
>
> You don't ever "need" nulls. There always exists an equivalent RM schema
> that does not contain any nullable attributes. Nulls and outer joins are
> conveniences that make it easier to answer existential queries.
>


Do you wish to continue with this script? Received on Thu Mar 16 2006 - 06:53:32 CST

Original text of this message

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