| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: functional dependencies
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 - 04:24:58 CDT
![]() |
![]() |