Assume:

The isbn uniquely identifies a book. $($It 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.

total CopiesOrdered is the number of copies of a book that the

bookstore has ever ordered, while copiesInStock 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 sellingPrice, 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 or distributor for the book.

a$.$ Using these assumptions and stating any others you need to

make, list all the nontrivial functional dependencies for this

relation.

b$.$ What are the candidate keys for this relation?

c$.$ Is the relation in $3$NF$?$ If not, find a $3$NF lossless join

decomposition of Books that preserves dependencies.

d$.$ Is the relation or resulting set of relations in Boyce$-$Codd

normal form? If not, find a lossless join decomposition that is