Re: yet another round of Fabian Pascal, C.J. Date - relational model, NULLs, Xquery, etc.

From: Nuno Souto <dbvision_at_optusnet.com.au>
Date: Wed, 30 Jun 2004 01:51:04 +1000
Message-ID: <40E18FE8.8010004@optusnet.com.au>

mkb apparently said,on my timestamp of 30/06/2004 1:28 AM:

> On another note:

>=20

> Incidentally, =93inapplicable values=94 are a red herring.

>=20

> They are an artifact of bad database design. There is
> only=20
> one kind of missing value =97 unknown =97 and as I
> demonstrate=20
> in the above-mentioned chapter, it can be handled
> relationally,=20
> without the huge problems of SQL=92s NULLs.
> <<<<

>=20

> can anyone point to an example...

>=20

Think along these lines:
1-1 optional relationships.

--=20
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_optusnet.com.au

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 29 2004 - 10:47:42 CDT