Friday, December 9, 2016

What is trivial functional dependency in dbms

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, a functional dependency A B is said to be trivial, if B is the subset or equal to that of A. That is, if you know the value of B already, you would uniquely determine the value of B.

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

Describe trivial functional dependency in normalization process

No comments:

Post a Comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery