Is possible to conserve the dependencies here?

From: Juan Pardillos <sicotom_at_eresmas.com>
Date: 17 Nov 2002 09:27:06 -0800
Message-ID: <6278687.0211170927.577b6222_at_posting.google.com>



Hi,

in the relation:

PROVIDER(PROVIDER_ID, STREET, CITY, STATE, ZIP_CODE) there are the following dependencies:

CITY, STATE, STREET -> ZIP_CODE
ZIP_CODE -> CITY, STATE Is it possible to decompose the previous relation and automatically preserve both functional dependencies?.

Thanks in advance Received on Sun Nov 17 2002 - 18:27:06 CET

Original text of this message