transitive dependency

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.

illucidAsked:
Who is Participating?
 
yorenConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.