Consider a relation BOOKS that holds information about the inventory of books (used or new) in a bookstore with attributes (titl
e, isbn, authorName, publisherName, publisherAddress, copyNumber, totalCopiesOrdered, copiesInStock, publicationDate, category, sellingPrice, cost, condition), as described below.
• All attributes listed above are atomic.
• The ISBN uniquely identifies a book. (However, it does not identify each copy of the book. If the bookstore has many copies of the same book, each copy is given a different copyNumber as described next)
• copyNumber corresponds to a particular copy of a book with a particular ISBN. For example, there may be copyNumber 34 of the book with ISBN = 123478, and copyNumber 34 of the book with ISBN = 987654.
• Each book has one publication date. A revision of a book, for example, a new edition, is given a new ISBN.
• A book may have more than one author.
• An author may have more than one book.
• Each book has one publisher.
• Each publisher name is unique. Each publisher has one 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 copiesInStock is the number still unsold in the bookstore.
• condition describes the condition of a particular copy of a book and is one of "excellent", "very good", "good", "fair" Each book has one category. The category may be biography, science fiction, poetry, and so on.
• 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 paid to acquire the book.
What is the highest normal form that the BOOKS relation is in? (Justify your answer using functional dependencies.)
