"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
