Skip to content
Related Articles

Related Articles

UGC-NET | UGC NET CS 2017 Jan – III | Question 10
  • Last Updated : 02 Apr, 2018
GeeksforGeeks - Summer Carnival Banner

For a database relation R(A, B, C, D) where the domains of A, B, C and D include only atomic values, only the following functional dependencies and those that can be inferred from them are :
A → C
B → D
The relation R is in _______.
(A) First normal form but not in second normal form.
(B) Both in first normal form as well as in second normal form.
(C) Second normal form but not in third normal form.
(D) Both in second normal form as well as in third normal form.


Answer: (A)

Explanation: A relation is in first normal form if every attribute in that relation is single valued attribute. It is in 1NF.
{A,B} are prime attribtes and {C,D} are non-prime attribute.
A+ = {A,C}
B+ = {B,D}
{A,B}+ = {A,B,C,D} so AB is the key.
But A+ = {A,C}
B+ = {B,D} makes it partial dependency.
So, this relation is not in 2NF.
So, option (A) is correct.


Quiz of this Question

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :