Skip to content
Related Articles

Related Articles

Improve Article

GATE | GATE CS 1997 | Question 49

  • Difficulty Level : Easy
  • Last Updated : 22 Apr, 2020

For a database relation R(a,b,c,d), where the domains a, b, c, d include only atomic values, only the following functional dependencies and those that can be inferred from them hold:

{ a → c, b → d } 

This relation is
(A) in first normal form but not in second normal form
(B) in second normal form but not in first normal form
(C) in third normal form
(D) None of the above

Answer: (A)

Explanation: Candidate Key of above relation is :- ab only.

a and b is partial attribute (part of the CK) that’s why the given FD is partially dependents.

In 2NF there must not be partially dependents FD and we know that every table is already in 1NF.
Hence, this relation is in first normal form but not in second normal form.

Option (A) is correct.

Quiz of this Question

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :