Re: 3vl 2vl and NULL

From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Wed, 04 Jan 2006 10:45:55 -0800
Message-ID: <044or1hj0oqlqn1p1jvhsgafnqksktp866_at_4ax.com>


On 3 Jan 2006 18:40:46 -0800, "dawn" <dawnwolthuis_at_gmail.com> wrote:

[snip]

>I think of modeling data with both tags (domain names) and values.
>Take a simple screen for displaying a person's first name, last name,
>all values for e-mail address and first names of all children. We can
>surely model this data with multiple relations and we could also use a
>single relation with nested relations to model it if we add in data for
>ordering, but we cannot model this view of the data with an SQL view.
>We could potentially have a cartesian product view that includes all of
>the data for the screen, but it does not use the same data model as the
>view. The data model for the screen is not in 1st normal form and SQL
>requires 1NF.

     A screen is not a database. It is more like a report. There is no reason for it to be in 1NF.

[snip]

Sincerely,

Gene Wirchenko Received on Wed Jan 04 2006 - 19:45:55 CET

Original text of this message