Database MCQ Set 1 1. 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…