Advanced Database Management System - Tutorials and Notes: What is trivial functional dependency in dbms

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Friday, 9 December 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