2078 8

Database Management System20785 marksFunctional Dependencies

Define Functional dependencies. Explain trivial and non trivial dependencies?

Define Functional dependencies. Explain trivial and non trivial dependencies? [5]

A functional dependency is a constraint between two sets of attributes in a relation. For a relation R, a functional dependency is denoted as: X → Y This means attribute (or set of attributes) X functionally determines attribute (or set of attributes) Y. In other words, for any two tuples t1 and ...

Up nextExplain the difference between 'Join' and 'Natural Join' of algebraic operations with exam