Re: MV Keys

From: Jon Heggland <heggland_at_idi.ntnu.no>
Date: Tue, 28 Feb 2006 08:38:21 +0100
Message-ID: <MPG.1e6e1c576dad2a0298976b_at_news.ntnu.no>


In article <1141000908.277461.101140_at_t39g2000cwt.googlegroups.com>, marshall.spight_at_gmail.com says...
> If pure 1NF were always the exactly right thing to do, we wouldn't
> have varchar. Instead we'd just use another relation, with tuples
> like (foreign key, position, character). Would anyone like that?
> No!
>
> (The canonical objection here would be performance. For the
> thought experiment, just imagine it's free.)
>
> Instead of doing this, we allow attributes of list type.
> List! Special cased for character lists only, though,
> perhaps so we can better convince ourselves that
> we didn't just throw in a non-1NF construct. :-)

What definition of 1NF do you use? I'm asking in earnest; there are quite a few different definitions floating around.

-- 
Jon
Received on Tue Feb 28 2006 - 08:38:21 CET

Original text of this message