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

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

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@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 - 11:27:06 CST

Original text of this message

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