GATE 2017 [Set-1]
October 15, 2023Web-Technologies
October 15, 2023Database-Management-System
|
Question 98
|
Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold: {A → B, BC → D, E → C, D → A}. What are the candidate keys of R?
|
AE, BE
|
|
|
AE, BE, DE
|
|
|
AEH, BEH, BCH
|
|
|
AEH, BEH, DEH
|
Question 98 Explanation:
Using the given functional dependencies and looking at the dependent attributes, E and H are not dependent on any. So, they must be a part of any candidate key.
So only option (D) contains E and H as part of candidate key.
So only option (D) contains E and H as part of candidate key.
Correct Answer: D
Question 98 Explanation:
Using the given functional dependencies and looking at the dependent attributes, E and H are not dependent on any. So, they must be a part of any candidate key.
So only option (D) contains E and H as part of candidate key.
So only option (D) contains E and H as part of candidate key.
Subscribe
Login
0 Comments