Multi Value Dependency, BCNF, 4NF

At http://www.slideshare.net/ramsekhargrandhi/mvd-16251057 in side 4 of 14 shown below...

Question: Why name --> --> phone is a multi valued Dependent?

I understand FD in name --> adress. But why we cannot have name --> phone.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Phone is directly related to a person (name), and not an address, e.g. my cell phone doesn't *really* have an address related to it.

So, given a table Name was a table, then
Phone would be a 1:M table with fk name, as a name can have multiple phone numbers.
Address could be in the Name table if you don't care about history, or if a name can have multiple addresses.  If you need history, then Address is a separate 1:M table with fk name and some kind of date column(s) to indicate when the address was valid.

No relationship between phone and address.
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi Jim,

Dirinkers  <--- Table name with 3 fields
========================
name
phone
address

The discussion, as I understand it, to see if this table could be further reduced (broken down to two tables) and why. So, name and phone (if it is cell phone) is candidate key. The combination of  name-cell phone - and address possibly is another candidate key if all names are living alone but we never know. As the result

name --> cell -phone have functional dependency (FD) but
name --> address have not and definately
name - -> beer type have not FD because Mike --> Coors   cannot be unique because we can easily have Robert --> Coors.

Now, lets forget the content of this post and shift to the original question:

Question: Why name --> --> phone is a multi valued Dependent?

The purpose of this post was just to not assume name, phone, address are each separate tables.

Thanks,

Mike
0
Scott PletcherSenior DBACommented:
@Jim:
>> Address could be in the Name table if you don't care about history, or if a name can have multiple addresses. <<

I believe you meant to say "or if name can have only a single address".  If a name can multiple addresses, then addresses need to be in a separate table, of course.


To me:
(name, phone, address) [beers]
is not even a valid setup of 4nf issues, as the table is not yet in 3nf.  

I believe the only true candidate key here is "name", since phone numbers change all the time.

Thus, phone and address are both non-key attributes, and, if so, we're dealing with potential 3nf issues, not 4nf issues.

I personally don't see any true transitive dependencies among phone, address and beers.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Mike EghtebasDatabase and Application DeveloperAuthor Commented:
HI Scott,

Could you possibly, in a table like:

Table1
===========================
field1          field2                field3
---------         -----------            -------------
x                    x                          x

give me an examples for FD and MVD?

Basically, I want to understand FD and MVD.

Also, please add a comment to: http://www.experts-exchange.com/Database/MS-SQL-Server/Q_28584856.html#a40512198

Thanks,

Mike
0
Scott PletcherSenior DBACommented:
Sorry, I need to come back to this.  I've had only about 2 hours' sleep in the last two days so now is the time for me to tackling normalization :-).  Even what I have above is not really clear or direct.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Question: Why name --> --> phone is a multi valued Dependent?

 I understand FD in name --> adress. But why we cannot have name --> phone.
Both can be true but it's more usual to a person having more than a telephone number where he/she can be reached. Like mobile phone, home phone and work phone.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.