Consider the following relational schemas for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, with the following dependencies :I. Title, Author —> Catalog_noII. Catalog_no —> Title, Author, Publisher, YearIII. Publisher, Title, Year —> PriceAssume (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