Q22,p3,j14. Consider the following relational schemas for a library database :

Book (Title, Author, Catalog_no, Publisher, Year, Price)

Collection(Title, Author, Catalog_no)

with the following functional

dependencies :

I. Title, Author →Catalog_no

II. Catalog_no →Title, Author, Publisher, Year

III. Publisher, Title, Year →Price

Assume (Author, Title) is the key for both schemas. Which one of the

following is true ?

(A) Both Book and Collection are in BCNF.

(B) Both Book and Collection are in 3NF.

(C) Book is in 2NF and Collection in 3NF.

(D) Both Book and Collection are in 2NF. 

Answer c.

Explanation. Book has transitive dependency hence book is not in 3nf and in Bcnf.

Collection is in 2nf and 3nf because all the non key attributes are functional dependent on

Key hence it is in 2nf and no transitive dependency hence collection is  in 3nf.