Consider a relation BOOKS that holds information about the inventory of books (used or new) in a bookstore with attributes (title, isbn, authorName, publisherName, publisherAddress, copyNumber, total- CopiesOrdered, copiesInStock, publicationDate, category, selling Price, 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. 3 of 5
• 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 head- quarters.
• 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.
Required:
What is the highest normal form that the BOOKS relation is in? (justify your answer using functional dependencies)