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:

  1. A.

    A, B only

  2. B.

    A, C only

  3. C.

    B, C only

  4. D.

    A,B, C only

Attempted by 39 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…