Tutorial 1
Database Management System
Functional Dependency
Ques 1: The following functional dependencies are given: AB->CD,
AF->D, DE->F, C->G , F->E, G->A Which one of the following
options is false?
A. CF+ = {ACDEFG}
B. BG+ = {ABCDG}
C. AF+ = {ACDEFG}
D. AB+ = {ABCDFG}
Ques 2: In a schema with attributes A, B, C, D and E, following set
of functional dependencies are given: A->B A->C CD->E B->D E-
>A Which of the following functional dependencies is NOT
implied by the above set?
A. CD->AC
B. BD->CD
C. BC->CD
D. AC->BC
Ques 3: From the following instance of a relational schema R(A,
B, C), we can conclude that:
A B C
1 1 1
1 1 0
2 3 2
2 3 2
A. A functionally determines B and B functionally determines C
B. A functionally determines B and B does not functionally
determine C
C. B does not functionally determine C
D. A does not functionally determine B and B does not functionally
determine C
Ques 4: Consider the following set0F0of functional dependencies:
F={A BC, BC, AB, ABC}.
Find the canonical cover.
Ques 5: Consider the following set of functional dependency on
the scheme (A, B,C)
A→BC, B→C, A→B, AB→C. The canonical cover for this set is:
