# UGC-NET | UGC NET CS 2017 Jan – III | Question 10

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.

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 attributes 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

Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Previous
Next