Re: functional dependencies
From: andrewst <member14183_at_dbforums.com>
Date: Wed, 11 Jun 2003 09:24:58 +0000
Message-ID: <2988618.1055323498_at_dbforums.com>
Date: Wed, 11 Jun 2003 09:24:58 +0000
Message-ID: <2988618.1055323498_at_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.comReceived on Wed Jun 11 2003 - 11:24:58 CEST