Re: A Normalization Question

• Post for FREE via your newsreader at post.usenet.com ****

"Neo" <neo55592_at_hotmail.com> wrote in message news:4b45d3ad.0407271130.60786b9e_at_posting.google.com...
> > > > > One can't derive that 'brown is composed of b, r, o, w, n' from an
> > > > > empty db; but a demo could convince me otherwise.
> > > >
> > > > SELECT "brown" AS [string], spell('brown') AS spelling;
> > > > Function spell(s As String) As String
> > >
> > > Try removing 'brown' from your SQL and see if it works.
> >
> > It could be replaced by a parametrized query
> > that ask the user for the string.

> In that case, the info to spell 'brown' is coming from the user, not > from an empty db.

Yes. The user ask the DBMS to spell 'brown'. For asking this, the user need to know how to spell 'brown' :-) This is why an empty db suffices :-)

> > So the info isn't coming from the particular string 'brown'.

> Maybe not, but how does this show derivation from an empty db. It
> seems to show derivation from a non-particular string 'brown' outside
> the db.

Like this:
{}|-- spelling("brown","brown")
because All(x) spelling(x,x)

:-)

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=