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

Home -> Community -> Usenet -> comp.databases.theory -> Re: functional dependencies

Re: functional dependencies

From: andrewst <member14183_at_dbforums.com>
Date: Wed, 11 Jun 2003 09:24:58 +0000
Message-ID: <2988618.1055323498@dbforums.com>

Originally posted by Rohan Hathiwala
> Now let me rephrase my original question (in quotes).
> "Give me an example of a relation where there is an FD where the
> attributes invloved are not key attributes and also see to that
> it does not violate any of the normal forms."
>

But if there is an FD A->B where A is not a key attribute then the relation not normalised by definition: "The data shall depend on the key, the whole key and nothing but the key". So what you ask for an example of cannot exist!

--
Posted via http://dbforums.com
Received on Wed Jun 11 2003 - 04:24:58 CDT

Original text of this message

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