Question 11068 – Set-Theory
January 9, 2024Question 8489 – Constraints
January 9, 2024Question 11106 – ER-Model
In a schema with attributes A, B, C, D and E following set of functional dependencies are given
A → B A → C CD → E B → D E → A
Which of the following functional dependencies is NOT implied by the above set?
Correct Answer: B
Question 2 Explanation:
Apply membership test for all the functional dependencies.
Option (B):
BD → CD
BD+ = BD
i.e., BD cannot derive CD and hence is not implied.
Option (B):
BD → CD
BD+ = BD
i.e., BD cannot derive CD and hence is not implied.
CD → AC
BD → CD
BC → CD
AC → BC
Subscribe
Login
0 Comments