RSA-algorithm
October 15, 2023Web-Technologies
October 15, 2023Functional-Dependency
| Question 12 |
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 12 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 12 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