Re: Data Display & Modeling

Dawn M. Wolthuis wrote:

> Therefore, I see no reason for that R part in any aspect of the system,
> other than (recent) tradition and the fact that a ton of data has been
> (unnecessarily) placed in 1NF. If the application of relational processes
> were really loss-less, then the data could be viewed the way I like to see
> it (but, alas, while non-1NF databases have no problem showing themselves as
> if they were relational, the reverse is often not the case).
>
> I'd like to see diagramming tools for data modeling to specify data in its
> more conceptually simple format of propositions as functions that need not
> be in 1NF, showing foreign key links and such -- a web of data.

Could you please refine a little on what's wrong with 1NF ?

I take 1NF to mean:

1. no duplicates b-1. no internal structure in attributes b-2. no lists/array attributes (MV)

You have been talking a lot about b-2, but what about a and b-1 (or aspects I've missed) ? Received on Fri May 07 2004 - 19:59:01 CDT