Database-Management-System
November 12, 2023Question 4374 – Research Aptitude
November 13, 2023Database-Management-System
Question 43 |
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 43 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 43 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.
Subscribe
Login
0 Comments