Consider the following relational schemes for a library for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
Which ofthe following functional dependecies:
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 ofthe following statements is true?
| A. | Both Book and collection are in BCNF |
| B. | Both Book and collection are in 3NF only |
| C. | Book is in 2NF and Collection is in 3NF |
| D. | Both Book and Collection are in 2NF only |
Answer : C Explanation : |
|
|
Option: A Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. |
