Open In App
Related Articles

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

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
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 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

Last Updated : 21 Dec, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads