UGC-NET | UGC NET CS 2018 Dec – II | Question 49

Consider the schema R=(A, B, C, D, E, F) on which the following functional dependencies hold :

A ➝ B
B,C ➝ D
E ➝ C
D ➝ A

What are the candidate keys of R ?
(A) AEF, BEF and DEF
(B) AEF, BEF and BCF
(C) AE and BE
(D) AE, BE and DE

Answer: (A)
Explanation: Closure of attributes,

Closure of AEH, i.e. AEH+ = {ABCDEF}
Closure of BEH, i.e. BEH+ = {ABCDEF}
Closure of DEH, i.e. DEH+ = {ABCDEF}

Option (A) is correct.
Quiz of this Question

Article Tags :

UGC-NET

Recommended Articles

1. UGC-NET | UGC NET CS 2018 Dec – II | Question 27

2. UGC-NET | UGC NET CS 2018 Dec – II | Question 1

3. UGC-NET | UGC NET CS 2018 Dec – II | Question 2

4. UGC-NET | UGC NET CS 2018 Dec – II | Question 3

5. UGC-NET | UGC NET CS 2018 Dec – II | Question 4

6. UGC-NET | UGC NET CS 2018 Dec – II | Question 5

7. UGC-NET | UGC NET CS 2018 Dec – II | Question 6

8. UGC-NET | UGC NET CS 2018 Dec – II | Question 7

9. UGC-NET | UGC NET CS 2018 Dec – II | Question 8

10. UGC-NET | UGC NET CS 2018 Dec – II | Question 9

11. UGC-NET | UGC NET CS 2018 Dec – II | Question 10

12. UGC-NET | UGC NET CS 2018 Dec – II | Question 11

13. UGC-NET | UGC NET CS 2018 Dec – II | Question 12

14. UGC-NET | UGC NET CS 2018 Dec – II | Question 13

15. UGC-NET | UGC NET CS 2018 Dec – II | Question 14

16. UGC-NET | UGC NET CS 2018 Dec – II | Question 15

17. UGC-NET | UGC NET CS 2018 Dec – II | Question 16

18. UGC-NET | UGC NET CS 2018 Dec – II | Question 17

19. UGC-NET | UGC NET CS 2018 Dec – II | Question 18

20. UGC-NET | UGC NET CS 2018 Dec – II | Question 19

21. UGC-NET | UGC NET CS 2018 Dec – II | Question 20

22. UGC-NET | UGC NET CS 2018 Dec – II | Question 21

23. UGC-NET | UGC NET CS 2018 Dec – II | Question 22

24. UGC-NET | UGC NET CS 2018 Dec – II | Question 23

25. UGC-NET | UGC NET CS 2018 Dec – II | Question 24