WorksheetsFD 1
Total questions: 10
Worksheet time: 5mins
For R(A,B,C,D), the set of FDs F(A-> B, B-> C, C-> A). Which of the following is a candidate key
AD
AB
BC
D
For R(A,B,C, D), the set of FDs F(AB-> B, BC-> C, CD-> A). Which of the following is a candidate key
ACD
ABC
BC
BCD
Which of the following FD is redundant. For R(A,B,C), the set of FDs F(A-> AB, B-> C, A->B, C->B, B->A).
A->AB
B->C
B->A
None of the above
For R(A,B,C), the set of FDs F(A-> B, B-> C). Which of the following is NOT a SUPER key
ABC
AC
BC
AB
Following is the example of which axiom If X -> Y, then XZ -> YZ also XZ -> Y
Reflexive
Augmentation
Transitive
Union
Following is the example of which axiom If X -> YZ, then X -> Y and X -> Z
Reflexive
Transitive
Decomposition
Union
What are the prime attributes for the R = {A,B,C,D,E} with set of Fds Z={D -> E , CE-> A}
BCD
AE
CDE
CE
What are the NON-prime attributes for the R = {A,B,C,D,E,F,G} with candidate keys ABC, DF, ACG
E
A
ABC
DF
What are the prime attributes for the R = {A,B,C,D,E,F,G} with candidate keys ABC, DF, ACG
ABCD
ABCDF
ABCDFG
E
What are the NON-prime attributes for the R = {A,B,C,D,E,F,G} with candidate keys DCF & GCF
AB
ABE
C
CF
