## What is trivial functional dependency in DBMS? / Define trivial functional dependency / What is the trivial property in normalization process?

### Trivial Functional Dependency

A FD is said to be as Trivial, if it holds for all relations. In other words,

If all of the right hand side attributes are either subset or equal to the left hand side attributes in a functional dependency, then that particular functional dependency is said to be trivial.

For example,

*. That is, if you know the value of B already, you would uniquely determine the value of B.***a functional dependency A → B is said to be trivial, if B is the subset or equal to that of A**If all of the right hand side attributes are either subset or equal to the left hand side attributes in a functional dependency, then that particular functional dependency is said to be trivial.

For example,

- A → A is trivial,
- AB → B is trivial,
- {regno, phone} → phone and so on.

**Go to keywords page**

## No comments:

## Post a Comment