Search code examples
rdbms

What is mean cannonical cover?

I am new to DBMS.

I am learning the concept of integrity constraints. In this topic, i have a one sub topic. That is functional dependency. I am not able to understand this topic.

Please explain with examples for the following questions.

  1. What is Meant by functional dependency and what is the use of this in DBMS?
  2. What is meant by canonical cover and what is the use of this and how to find the canonical cover in the given relation?

Thanks for advance.

Solution

  • A canonical cover for F is a set of dependencies such that F logically implies all dependencies in tex2html_wrap_inline1324 , and vice versa.