Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Theory Questions concerning MVD and Functional Dependency.....
Vladimir,
Yes,
I believe so.
Suspense....Like I said I did not follow the whole multivalue dependency Thing.
MVD - A condition in a relation with three or more attributes in which independent attributes appear to have relationships they do not have. Formally in a relation R(A,B,C), having a key (A,B,C) where A is matched with multiple values of B (or of C or both), B does not determine C, and C does not de-termine B.
Nothing about A determining B or anything about A or B except A is matched with multiple values of B in a MVD situation. So If I assume the below definition of Function dependency;
Functional dependency is a relationship between attributes in which one attribute or group of attributes determines the value of another.
It is possible that A determines B, so the answer is True.
Thanks,
Chris
Vladimir M. Zakharychev wrote:
> Solomon_Man wrote:
> > All,
> > I am a student who just took there Final (yesterday) on DBMS as a
> > Graduate Student and a question is driving me crazy I need to know the
> > answer to.
> >
> > So here is the question;
> >
> > If A does not multidetermine B, it is still possible for A to determine
> > B. (TRUE OR FALSE).
> >
> > I have followed everything in this class till MVDs, and I am curious
> > about the answer to the above.
> >
> > Anyone have a clear way of explaing MVDs, I would be open to any help.
> >
> > Thanks in advance,
> > Chris
>
> Hmm... Isn't this question equivalent to "If there is no multivalued
> dependency between A and B, can there still be a functional dependency
> between them?"
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Received on Tue Dec 12 2006 - 11:45:34 CST