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: c.d.theory glossary - NULL

Re: c.d.theory glossary - NULL

From: Laconic2 <laconic2_at_comcast.net>
Date: Tue, 27 Apr 2004 12:18:40 -0400
Message-ID: <D9GdncHrpeo1GhPdRVn-iQ@comcast.com>


> >Second, the NULL marker (bit, if you like) is far from the insanity
bit.
>
> It is a botch up that breaks the logical framework.

And here's another difference between a logical model and a physical model. In a logical model,
if you are using relations as your modeling tool, then NULLS should not be allowed. The reason?
NULLS can't exist in a relation.

In the physical model, if you a modeling in terms of tables, rows and columns, there's no real reason to forbid NULLS in every column. Some columns should have NULLS forbidden in order to maintain entity integrity, but optional data is a possibility. Received on Tue Apr 27 2004 - 11:18:40 CDT

Original text of this message

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