Re: Second Normal Form help.

From: Peter Franklin <p.franklinDeleteThis_at_which.net>
Date: Fri, 30 Mar 2001 11:19:36 GMT
Message-ID: <3ac46b0e.7447510_at_news.which.net>


James, beware - everything Tom has been writing about 2NF is nonsense.

On Fri, 30 Mar 2001 02:48:02 +0100, James Taylor <james_at_NOSPAM.demon.co.uk> wrote:

>Tom wrote:
>> Yeah, Im pretty sure..
>>
>> James_one wrote:
>> > Is a concatenated primary key the same as a compound primary key?
>> >
>> > James_one wrote:
>> > > Cool, thanks!
>> > >
>> > > Tom wrote:
>> > > > Yeah, that'll do it.
>> > > >
>> > > > James_one wrote:
>> > > > > So Garages should have it's own unique key and...
>> > > > >
>> > > > > Tom wrote:
>> > > > > > Sure, Its valid in first normal form.
>> > > > > >
>> > > > > > James_one wrote:
>> > > > > > > Is that not a valid primary key, the combination of
>> > > > > > > BuildingID and GarageNumber?
>> > > > > > >
>> > > > > > > Tom wrote:
>> > > > > > > > I meant GarageNumber. Sorry.
>> > > > > > > >
>> > > > > > > > Tom wrote:
>> > > > > > > > >
>> > > > > > > > > James_one wrote:
>> > > > > > > > > > My question is about the garages table.
>> > > > > > > > > > Is it in second normal form?
>> > > > > > > > >
>> > > > > > > >
>> > > > > > >
>> > > > > >
>> > > > >
>> > > >
>> > >
>> >
>>
>
>It baffles me why Microsoft Outlook Express users always talk in reverse
>as typified by the exchange above. I've not used it myself so perhaps
>someone could tell me what user interface flaw causes users to do this?
>It is because it does not allow them to trim the quoted material, and/or
>does not show them the quoted material in the same window as that which
>they type their message in? Or perhaps it's just because there is a strong
>inverse correlation between Outlook users and Usenet aficionados. Any
>help understanding this annoying phenomenon would be much appreciated.
>
>Thanks.
>
>--
>James Taylor <james (at) oakseed demon co uk>
>Based in Hammersmith, London, UK.
>PGP key available ID: 3FBE1BF9
>Fingerprint: F19D803624ED6FE8 370045159F66FD02
>
Received on Fri Mar 30 2001 - 13:19:36 CEST

Original text of this message