A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. Consider the following relational schemes for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) with in 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?
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:Book is in 2NF and Collection is in 3NF
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: