Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!79g2000cws.googlegroups.com!not-for-mail
From: "Solomon_Man" <cmgray74@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Theory Questions concerning MVD and Functional Dependency.....
Date: 12 Dec 2006 09:45:34 -0800
Organization: http://groups.google.com
Lines: 56
Message-ID: <1165945534.581169.119110@79g2000cws.googlegroups.com>
References: <1165933367.087896.262660@f1g2000cwa.googlegroups.com>
   <1165944291.728656.317640@j44g2000cwa.googlegroups.com>
NNTP-Posting-Host: 208.46.47.5
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165945540 13115 127.0.0.1 (12 Dec 2006 17:45:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 17:45:40 +0000 (UTC)
In-Reply-To: <1165944291.728656.317640@j44g2000cwa.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 79g2000cws.googlegroups.com; posting-host=208.46.47.5;
   posting-account=kLePdg0AAAA1K_S794Fa_4gyG8Sgcp-i
Xref: usenetserver.com comp.databases.oracle.server:419032
X-Received-Date: Tue, 12 Dec 2006 12:45:40 EST (text.usenetserver.com)

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