Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Functional-Dependency
| Question 14 |
Consider the following dependencies :
AB → CD, AF → D, DE → F, C → G, F → E, G → A
Which one of the following options is false ?
| BG+={ABCDG} | |
| CF+={ACDEFG} | |
| AB+={ABCDG} | |
| AF+={ACDEFG} |
Question 14 Explanation:
(BG)+ = BGACD
(CF)+ = CFGEAD
(AB)+ = ABCDG
(AF)+ = AFDE
Hence option (D) is False.
(CF)+ = CFGEAD
(AB)+ = ABCDG
(AF)+ = AFDE
Hence option (D) is False.
Correct Answer: D
Question 14 Explanation:
(BG)+ = BGACD
(CF)+ = CFGEAD
(AB)+ = ABCDG
(AF)+ = AFDE
Hence option (D) is False.
(CF)+ = CFGEAD
(AB)+ = ABCDG
(AF)+ = AFDE
Hence option (D) is False.