Database MCQ

1:

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 the implied by the above set.

A.

CD —> AC

B.

BD --> CD

C.

BC —> CD

D.

AC —> BC

 

Answer : B

Explanation :

CD—>A     {CD —>E;E —> A; E —>C}
CD —> C
BC —> CD
B—>D;
CD—>E;
E—>A;
A—>C
AC—>BC:
A—>B:
A—>C

Naeem Ahmad said: (9:37pm on Thursday 11th June 2015)
This question is no correct. This should be like this..which of the following FDs is not implied by the above set.In this answer will be B.

Write your comments here:


Report Error
 

Option: A

Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here.