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