Functional Dependencies Database

In order to design a good database Functional Dependencies in Database is an important concept. In order to ensure the integrity of data and a good performance of a database functional dependencies plays an important role. Definition of Functional Dependency on Wikipedia HERE.

Suppose we have a relation in database where there are only two attributes X and Y:

Functional Dependency Def.

X –> Y

if t1.X = t2.X then t1.Y = t2.Y

To read more visit https://hecodesit.com/functional-dependencies-database/