Re: 1NF (Marshall)
From: paul c <toledobythesea_at_oohay.ac>
Date: Sat, 20 Jan 2007 19:23:58 GMT
Message-ID: <i%tsh.728203$5R2.327201_at_pd7urf3no>
Date: Sat, 20 Jan 2007 19:23:58 GMT
Message-ID: <i%tsh.728203$5R2.327201_at_pd7urf3no>
Marshall wrote:
> ...
> It does seem to me, though, that despite any relaxing of 1NF,
> we can get ourselves in to trouble with too much nesting.
> However the reverse isn't true; there is no trouble associated
> with unnesting. At worst you are talking inconvenience.
> ...
I have a problem with unnesting of some relations. If I have relation that has the unique combinations of parts ever shipped to any customer, eg.,
S{{P#}} = {
{p1,p2}, {p1,p3} }
and I unnest it I get
SU{P#} = {
p1, p2, p3 }.
p Received on Sat Jan 20 2007 - 20:23:58 CET