ISRO | ISRO CS 2013 | Question 25

Consider the following dependencies and the BOOK table in a relational database design. Determine the normal form of the given relation.

ISBN → Title
 ISBN → Publisher
 Publisher → Address 

(A) First Normal Form
(B) Second Normal Form
(C) Third Normal Form
(D) BCNF


Answer: (B)

Explanation: Candidate key = ISBN
For a relation having functional dependencies of the form α → β, a relation is in 2-NF if:
i) α should not be a proper subset of the candidate key, or,
ii) β – α should be a prime attribute.

First condition satisfies as the candidate key contains only one attribute.

So, this relation is in 2-NF

Quiz of this Question