Solved

transitive dependency

Posted on 2003-11-11
1
2,252 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
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Facebook React and SyntheticEvents 6 64
Queries 15 38
PL/SQL Display based on value 4 26
Use of Exception to end a Loop 3 31
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 …
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.
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).

776 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