b) What are the candidate keys for this relation? Identify the primary key.

c) Is the relation in third normal form? If not, find a 3NF lossless join decomposition of Books that perserves dependencies.

d) Is the relation or resulting set of relations in Boyce-Codd Normal Form? If not, find a lossless join decomposition that is in BCNF. Identify any functional dependencies that are not preserved.

6.1 Consider the following universal relation that holds information about the inventory of books in a bookstore Books (title, isbn author, publisherName publisher Add tot alCopies0rdered copies In Stock, publicationDate category selling Price cost) Assume: The isbn uniquely identifies a book. (t does not identify each copy of the book, however.) A book may have more than one author. An author may have more than one book. Each publisher name is unique. Each publisher has one unique address-the address of the firm's national headquarters. Titles are not unique. totalCopiesordered is the number of copies of a particular book that the bookstore has ever ordered, while copies InStock is the number still unsold in the bookstore. Each book has only one publication date. A revision of a book is given a new ISBN. The category may be biography, science fiction, poetry, and so on The title alone is not sufficient to determine the category. The selling Price, which is the amount the bookstore charges for a book, is always 20 percent above the cost, which is the amount the bookstore pays the publisher ordistributor for the book. a. Using these assumptions and stating any others you need to make, list all the non-trivial functional dependencies for this relation. 6.1 Consider the following universal relation that holds information about the inventory of books in a bookstore Books (title, isbn author, publisherName publisher Add tot alCopies0rdered copies In Stock, publicationDate category selling Price cost) Assume: The isbn uniquely identifies a book. (t does not identify each copy of the book, however.) A book may have more than one author. An author may have more than one book. Each publisher name is unique. Each publisher has one unique address-the address of the firm's national headquarters. Titles are not unique. totalCopiesordered is the number of copies of a particular book that the bookstore has ever ordered, while copies InStock is the number still unsold in the bookstore. Each book has only one publication date. A revision of a book is given a new ISBN. The category may be biography, science fiction, poetry, and so on The title alone is not sufficient to determine the category. The selling Price, which is the amount the bookstore charges for a book, is always 20 percent above the cost, which is the amount the bookstore pays the publisher ordistributor for the book. a. Using these assumptions and stating any others you need to make, list all the non-trivial functional dependencies for this relation