Re: Few confusing things about first normal form
Date: Sat, 1 Nov 2008 05:03:31 -0700 (PDT)
Message-ID: <76d81dee-e37a-41c3-8eb7-268b03bc4967_at_e1g2000pra.googlegroups.com>
On Oct 23, 1:43 pm, Gene Wirchenko <ge..._at_ocis.net> wrote:
> Sru..._at_gmail.com wrote:
>
> [snip]
>
> >Anyways, I realize SQL doesn’t allow multi-valued attributes, but I
> >figured at least in theory they would be allowed, since I can’t bring
> >myself to believe that the author of my book was so off. Uh
>
> No, they are not allowed under the RM, and there are good reasons
> for this. (You can break up multi-valued attributes into another
> relation.)
The solution that makes rdbms purists happy is to declare the entire repeating group be instead a string or blob and let the application deal with the repeating-groupedness of the actual data.
> >thank you all for helping me
Your welcome! Received on Sat Nov 01 2008 - 13:03:31 CET