Computer Science, asked by sasankbvmsmart, 1 month ago

Consider a relation Books as given below: BOOKS(bookID, booktitle, publisherid, publishyear, numpages, TR-ID) It contains information on books published by publishers. Each book has a unique ID given by its publishing house, a title, and publisher id who published it in a particular year with some number of pages. Also, if the book previously appeared in a "technical review" (TR), the ID of this technical review is specified. Based on this information, choose the key for relation BOOKS​

Answers

Answered by ManuvalTittus
0

Answer:

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: (C)

Explanation:

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

The table “Collection” is in BCNF as there is only one functional dependency “Title Author –> Catalog_no” and {Author, Title} is key for collection.

Book is not in BCNF because Catalog_no is not a key and there is a functional dependency “Catalog_no –> Title Author Publisher Year”.

Book is not in 3NF because non-prime attributes (Publisher Year) are transitively dependent on key [Title, Author].

Book is in 2NF because every non-prime attribute of the table is either dependent on the whole of a candidate key [Title, Author], or on another non prime attribute.

In table book, candidate keys are {Title, Author} and {Catalog_no}. In table Book, non-prime attributes (attributes that do not occur in any candidate key) are Publisher, Year and Prince

Please refer Database Normalization | Normal Forms for details of normal forms.

Explanation:

I think it would help you

Similar questions