Re: looking for old Datamation poster on Normalizing

From: David Cressey <dcressey_at_verizon.net>
Date: Sat, 26 Aug 2006 14:53:58 GMT
Message-ID: <agZHg.987$dj4.887_at_trndny08>


"-CELKO-" <jcelko212_at_earthlink.net> wrote in message news:1156602629.218978.8850_at_m73g2000cwd.googlegroups.com...
> >> I used to have a useful poster that I probably got as a freebie from
Datamation magazine about 20 years ago. It nicely explained the various Normal Forms and I think it used some sort of dog breeding example. <<
>
> "Five Rules of Data Normalization" from Database Progamming & Design
> magazine; DATAMATION was out of business by then. I have one on my
> wall in a frame, but I might have an extra in the garage; I will look
> this weekend. It was reprinted once or twice because it was so
> popular.
>

PMFJI. I've allways been disturbed by the presentation of 4NF in the "puppies & tricks" poster. It seems to me that there's a misprint, somewhere, or that the key of one of the tables has undergone a shift between the 3NF example and the 4NF example. Am I the only one who sees a problem, or has this been discussed before? Received on Sat Aug 26 2006 - 16:53:58 CEST

Original text of this message