Question 10005 – Database-Management-System
November 12, 2023Question 4374 – Research Aptitude
November 13, 2023Question 9901 – Database-Management-System
Let R = (A, B, C, D, E, F) be a relation scheme with the following dependencies: C→F, E→A, EC→D, A→B. Which of the following is a key of R?
Correct Answer: B
Question 26 Explanation:
Let’s check closure for each option,
A) (CD)+ = cdf
Not a key.
B) (EC)+ = ecdabf
Yes, it is a key.
C) (AE)+ = aeb
Not a key.
D) (AC)+ = abcf
Not a key.
A) (CD)+ = cdf
Not a key.
B) (EC)+ = ecdabf
Yes, it is a key.
C) (AE)+ = aeb
Not a key.
D) (AC)+ = abcf
Not a key.
CD
EC
AE
AC
Subscribe
Login
0 Comments