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