Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Is possible to conserve the dependencies here?

Re: Is possible to conserve the dependencies here?

From: Damjan S. Vujnovic <damjan_at_galeb.etf.bg.ac.yu>
Date: Mon, 18 Nov 2002 12:06:52 -0800
Message-ID: <arahj0$jsk$1@news.etf.bg.ac.yu>


"Damjan S. Vujnovic" <damjan_at_galeb.etf.bg.ac.yu> wrote:
> Decompose into what (3NF, BCNF, ...)? If you are talking about decomposing
> into 3NF, then the answer is (always) yes (because there exists an
algorithm
> for decomposing into 3NF that preserves functional dependencies):
>
> PROVIDER1(PROVIDER_ID, CITY, STATE, STREET)
> PROVIDER2(PROVIDER_ID, ZIP_CODE)
> PROVIDER3(CITY, STATE, STREET, ZIP_CODE)
Sorry, PROVIDER2 is excess... PROVIDER1 and PROVIDER3 are the two relations you asked for. Received on Mon Nov 18 2002 - 14:06:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US