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.