Question 7942 – Relational-Algebra
May 3, 2024Database-Management-System
May 3, 2024Database-Management-System
| Question 806 |
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 ?
| AEF, BEF and DEF
| |
| AEF, BEF and BCF | |
| AE and BE | |
| AE, BE and DE |
Question 806 Explanation:
EFA+ = {EFABCD}
EFB+ = {EFABCD}
EFC+ = {EFC}
EFD+ = {EFDCAB}
So, EFA, EFB, EFD are the keys for the given relation R = (A, B, C, D, E, F).
EFB+ = {EFABCD}
EFC+ = {EFC}
EFD+ = {EFDCAB}
So, EFA, EFB, EFD are the keys for the given relation R = (A, B, C, D, E, F).
Correct Answer: A
Question 806 Explanation:
EFA+ = {EFABCD}
EFB+ = {EFABCD}
EFC+ = {EFC}
EFD+ = {EFDCAB}
So, EFA, EFB, EFD are the keys for the given relation R = (A, B, C, D, E, F).
EFB+ = {EFABCD}
EFC+ = {EFC}
EFD+ = {EFDCAB}
So, EFA, EFB, EFD are the keys for the given relation R = (A, B, C, D, E, F).
Subscribe
Login
0 Comments