Database-Management-System
|
Question 46
|
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?
|
CD
|
|
|
EC
|
|
|
AE
|
|
|
AC
|
Question 46 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.
Correct Answer: B
Question 46 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.