Consider the following dependencies and the BOOK table in a relational…

2013

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
  1. A.

    First Normal Form

  2. B.

    Second Normal Form

  3. C.

    Third Normal Form

  4. D.

    BCNF

Attempted by 497 students.

Show answer & explanation

Correct answer: B

First, identify the primary key. ISBN determines Title and Publisher, so ISBN is the candidate key. Since it is a single attribute, there are no partial dependencies, satisfying Second Normal Form (2NF). However, Publisher → Address exists. Since Publisher is not a superkey and depends on the key (ISBN), this creates a transitive dependency. This violates Third Normal Form (3NF). Therefore, the relation is in Second Normal Form.

Explore the full course: Isro