Re: two nasty schemata, union types and surrogate keys

From: Brian <brian_at_selzer-software.com>
Date: Fri, 25 Sep 2009 04:35:11 -0700 (PDT)
Message-ID: <68b817f1-ec6f-4db7-bd96-99a42bc93f8c_at_g1g2000vbr.googlegroups.com>



On Sep 25, 6:04 am, Roy Hann <specia..._at_processed.almost.meat> wrote:
> Brian wrote:
> > What does the closed world assumption have to do with violating 5NF?
>
> You can't have a violation of 5NF without it.
>
> --
> Roy

Yes, you can. Suppose that you have the scheme

{Supplier, SupplierPhone, PartNumber}

which satisfies the functional dependencies

PartNumber --> Supplier --> SupplierPhone

This is a violation of 5NF because it is a violation of 3NF. Under the open world interpretation, what is in the database is what is known to be true, but that doesn't change the fact that if you delete the row with the only part known to be supplied by a particular supplier, you also erase the knowledge that that particular supplier has a particular phone number. Received on Fri Sep 25 2009 - 06:35:11 CDT

Original text of this message