Question 3248 – Communication
March 26, 2024Database-Management-System
March 26, 2024Database-Management-System
| Question 240 |
Let R = (A, B, C, D, E) having following FD’s.
F = {A → BC, CD → E, B → D, E → A}
Which of the following is not a Candidate key?
F = {A → BC, CD → E, B → D, E → A}
Which of the following is not a Candidate key?
| A | |
| B | |
| E | |
| BC |
Question 240 Explanation:
Closure(A)+ = { A, B, C, D, E }
Closure(B)+ = { B, D }
Closure(E)+ = { A, B, C, D, E }
Closure(BC)+ = { A, B, C, D, E }
Closure(B)+ = { B, D }
Closure(E)+ = { A, B, C, D, E }
Closure(BC)+ = { A, B, C, D, E }
Correct Answer: B
Question 240 Explanation:
Closure(A)+ = { A, B, C, D, E }
Closure(B)+ = { B, D }
Closure(E)+ = { A, B, C, D, E }
Closure(BC)+ = { A, B, C, D, E }
Closure(B)+ = { B, D }
Closure(E)+ = { A, B, C, D, E }
Closure(BC)+ = { A, B, C, D, E }