Question

What is functional depdency in normalisation?

Answer 1

Answer:

Functional dependency (FD) is a set of constraints between two attributes in a relation. ... Functional dependency is represented by an arrow sign (→) that is, X→Y, where X functionally determines Y. The left-hand side attributes determine the values of attributes on the right-hand side.

Explanation:

.

.

.

.

_______

Answer 2

Answer:

In relational database theory, a functional dependency is a constraint between two sets of attributes in a relation from a database. In other words, a functional dependency is a constraint between two keys.

Functional dependency is represented by an arrow sign (→) that is, X→Y, where X functionally determines Y.