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