Match the following: List I List II I. 2NF (a) Transitive dependencies…

PYQ UGC NET 2010Modified — slightly modified from the official paper; see the solution

Match the following:

List I

List II

I. 2NF

(a) Transitive dependencies eliminated

II. 3NF

(b) Multivalued attribute removed

III. 4NF

(c) Contains no partial functional dependencies

IV. 5NF

(d) Contains no join dependency

Select the code for I, II, III, and IV.

  1. A.

    (a), (c), (b), (d)

  2. B.

    (d), (a), (b), (c)

  3. C.

    (c), (a), (b), (d)

  4. D.

    (d), (b), (a), (c)

Attempted by 38 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…