Consider the following relational schemas for a library database : Book…
PYQ UGC NET 2014
Consider the following relational schemas 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 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.
Attempted by 164 students.
Sign up free to check your answer
Sign up freeLoading lesson…

