Question - 4
Consider the following relational schemas for a library database :
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
with in the following functional dependencies
1. Title Author\(\rightarrow \) Catalog_no
2. Catalog_no\(\rightarrow \) Title Author Publisher Year
3. Publisher Title Year\(\rightarrow \) Price
Assume {Author, Title} is the key of both schemes.
Which of the following statement is true?
- A Both Book and Collection are in BCNF
- B Both Book and Collection are in 3 NF only
- C Book is in 2 NF and Collection is in 3NF
- D Both Book and Collection are in 2 NF only
