Relational Database Management System (RDBMS) Question:

Download Job Interview Questions and Answers PDF

What is Functional Dependency?

RDBMS Interview Question
RDBMS Interview Question

Answer:

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.

Download RDBMS Interview Questions And Answers PDF

Previous QuestionNext Question
What is normalization?When is a functional dependency F said to be minimal?