Question 149
Comprehension:
Answer question (146-150) based on the problem statement given below:
An organization needs to maintain database having five attributes A, B, C, D, E. These attributes are functionally dependent on each other for which functionally dependency set F is given as :
F : { A → BC, D → E, BC → D, A → D }.
Consider a universal relation R(A, B, C, D, E) with functional dependency set F. Also all attributes are simple and take atomic values only.
Identify the redundant functional dependency in F
Answer : 3. A → D Answer question (146-150) based on the problem statement given below:
An organization needs to maintain database having five attributes A, B, C, D, E. These attributes are functionally dependent on each other for which functionally dependency set F is given as :
F : { A → BC, D → E, BC → D, A → D }.
Consider a universal relation R(A, B, C, D, E) with functional dependency set F. Also all attributes are simple and take atomic values only.
Identify the redundant functional dependency in F
| Previous | Next |
| UGC NET CS December 2019 - Question 148 | UGC NET CS December 2019 - Question 150 |
A → D is redundant because A can determine D using other 2 FD's A → BC and BC → D.
So, option 3 is correct answer