Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

transitive dependency

Posted on 2003-11-11
1
Medium Priority
?
2,274 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 375 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

SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

715 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