An organization needs to maintain database having five attributes A, B, C, D,…
PYQ UGC NET 2019
An organization needs to maintain database having five attributes A, B, C, D, E. These attributes are functionally dependent on each other for which functionality dependency set 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 𝐹. Also all attributes are simple and take atomic values only.
Identify the redundant functional dependency in F
- A.
BC→D - B.
D→E - C.
A→D - D.
A→BC
Attempted by 544 students.
Sign up free to check your answer
Sign up freeLoading lesson…

