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,
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