Solved

transitive dependency

Posted on 2003-11-11
1
2,258 Views
Last Modified: 2013-11-19
Im confused by what this is, arent they the same thing??
       
      
partial functional dependency
Description       
In database terminology, a partial functional dependency occurs when the value in a non-key attribute of a table is dependent on the value of some part of the table's primary key (but not all of it).

       
transitive dependency
Description       
A transitive dependency occurs in a database table when the value of a non-key attribute is dependent on the value of another non-key attribute in that table.

0
Comment
Question by:illucid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
yoren earned 125 total points
ID: 9729019
No. Here's an example with both a transitive dependency and a partial functional dependency. Key is SID/Major -- this student has a double major

SID      Major            School            Maj_GPA            School_Location
123      Physics            Engineering      4.0            EngTown
123      Music            Arts            3.3            Artsville

Transitive dependency: School *determines* School_Location (School is not a key)
Partial functional dependency: Major determines School (Major is part of the key)

Now, remove the partial functional dependency:

SID      Major            Maj_GPA      
123      Physics            4.0            
123      Music            3.3      

Major      School            School_Location
Physics      Engineering      EngTown
Music      Arts            Artsville


Still have a transitive dependency. Now remove that:


SID      Major            Maj_GPA            
123      Physics            4.0            
123      Music            3.3            

Major      School
Physics      Engineering
Music      Arts

School            School_Location
Engineering      EngTown
Arts            Artsville


...and you're in 3rd normal form.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Select and Insert Query running slow 4 57
Procedure syntax 5 48
How to find the cost of a stored procedure in Oracle and optimize it ?? 2 35
Help with Oracle IF statment 5 35
Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
The viewer will learn how to count occurrences of each item in an array.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question