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 ?

  1. A.

    Both Book and Collection are in BCNF.

  2. B.

    Both Book and Collection are in 3NF.

  3. C.

    Book is in 2NF and Collection in 3NF.

  4. D.

    Both Book and Collection are in 2NF.

Attempted by 164 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…