Home > DeveloperSection > Interviews > What is Functional Dependency?

Posted on    September-22-2014 2:11 AM

 Database Database 
 1 Answer(s)
  662  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    September-22-2014 2:11 AM

A Functional dependency is denoted by X Y between two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple that can form a relation state r of R. The constraint is for any two tuples t1 and t2 in r if t1[X] = t2[X] then they have t1[Y] = t2[Y]. This means the value of X component of a tuple uniquely determines the value of component Y.

Don't want to miss updates? Please click the below button!

Follow MindStick