Consider the relation Student(stuid, dept, clsroll). The following functional…
PYQ UGC NET 2022
Consider the relation Student(stuid, dept, clsroll). The following functional dependencies are given:
FD1: stuid → dept; FD2: dept → stuid; FD3: stuid → clsroll; FD4: clsroll → stuid; FD5: dept → clsroll.
Which dependencies can be removed, one at a time, while preserving the closure of the original set?
A. FD2 and FD3; B. FD1 and FD5; C. FD5; D. FD1.
Choose the correct answer from the options given below:
- A.
A, B only
- B.
A, C only
- C.
B, C only
- D.
A,B, C only
Attempted by 39 students.
Sign up free to check your answer
Sign up freeLoading lesson…

