Re: Comparison of Oracle commans Vs. SQL Server Commands

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 28 May 2007 19:29:31 +0100
Message-ID: <xuGdneaCP4MVgsbbRVnyjgA@bt.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1180376147.132147_at_bubbleator.drizzle.com...
> David Portas wrote:
>>
>> Daniel, some time ago I pointed out that your description of Second
>> Normal Form is wrong:
>> http://www.psoug.org/reference/normalization.html
>>
>
> With respect to the 2NF definition I have looked at it several times
> and do not see the issue to which you are alluding. Please contact me
> off-line and be specific.

Daniel,

I'll take a guess that the objection is to the description:

when tables do not have composite primary keys

Although you have given an interpretation of what you mean by saying this, the wording will almost certainly make people think you mean 'single column' keys, rather than "keys of which a subsection can still be a key".

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Mon May 28 2007 - 13:29:31 CDT