Re: 3vl 2vl and NULL
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.
A screen is not a database. It is more like a report. There is
>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.
[snip]
Sincerely,
Gene Wirchenko
Received on Wed Jan 04 2006 - 19:45:55 CET