Q. Consider the following relational schemes 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 schemes. Which of the following statements is true?

• Both Book and Collection are in BCNF
• Both Book and Collection are in 3NF only
• Book is in 2NF and Collection is in 3NF
• Both Book and Collection are in 2NF only

Submit