Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 584
|
Let R ={A, B, C, D, E, F} be a relation schema with the following dependencies
C → F, E → A, EC → D, A → B Which of the following is a key for R ?
|
CD
|
|
|
EC
|
|
|
AE
|
|
|
AC
|
Question 584 Explanation:
Simple way to solve this question is,
→First we have to find the right hand side values of a dependencies. Check whether it cover all variables in a relation .
→In right hand side, CE are missing. It means definitely EC should be there in candidate key.
(EC)+=(A,B,C,D,E,F).
Remaining all are not satisfying candidate key properties.
→First we have to find the right hand side values of a dependencies. Check whether it cover all variables in a relation .
→In right hand side, CE are missing. It means definitely EC should be there in candidate key.
(EC)+=(A,B,C,D,E,F).
Remaining all are not satisfying candidate key properties.
Correct Answer: B
Question 584 Explanation:
Simple way to solve this question is,
→First we have to find the right hand side values of a dependencies. Check whether it cover all variables in a relation .
→In right hand side, CE are missing. It means definitely EC should be there in candidate key.
(EC)+=(A,B,C,D,E,F).
Remaining all are not satisfying candidate key properties.
→First we have to find the right hand side values of a dependencies. Check whether it cover all variables in a relation .
→In right hand side, CE are missing. It means definitely EC should be there in candidate key.
(EC)+=(A,B,C,D,E,F).
Remaining all are not satisfying candidate key properties.