Re: A Normalization Question

From: Neo <neo55592_at_hotmail.com>
Date: 6 Jul 2004 18:39:00 -0700
Message-ID: <4b45d3ad.0407061739.57ff6b12_at_posting.google.com>


> ...the whole purpose of normalization is to determine which things
> relate to which other things.

This is an incorrect understanding of normalization.

> You are overgeneralizing to the nth degree.

No, you/RM are undergeneralizing to the 5th degree.

> In normalization, one does not consider the values of the attributes...

The general form of normalization applies to all data models. Because RM is a limited data model, it is either impossible or impractical to normalize some types of data (ie values of attributes) while other data models (ie TDM) can.

> > If one chooses to ignore some things (ie 'brown', 'brown', 'brown'),
> > then one has a limited understanding/implementation of normalization.
>
> Please read SOMETHING about functional dependencies
> before you post this nonsense again.

RM incorrectly senses that 'brown', 'brown', 'brown' are not redunant, no matter how many times one rereads it, because it is a limited data model.  

> We are talking about relational databases.

I am talking about representing things in general and RM is only one limited method of doing so.

> Strings don't have attributes except ...

Sure they can as I have demonstrated earlier. It is not upto a data model to decide which data is "part of the data dictionary" or "in the normal business world". If it does, the data model is limited.

> _Entities_ have attributes.
> "Brown" is not an entity.

Because 'brown' can have attributes (ie language, typeset, font, size, color, blinking, etc) it can by your definition be an entity.

> Your view of this entire topic is completely twisted.

No, your/RM's view of this entire topic is completely limited. Received on Wed Jul 07 2004 - 03:39:00 CEST

Original text of this message