Is possible to conserve the dependencies here?
Date: 17 Nov 2002 09:27:06 -0800
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