Computers and Technology

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, 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.)

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 18:00, kayleeemerson77
Ihave buncha points. does anyone want any?
Answers: 1
image
Computers and Technology, 21.06.2019 22:30, kivking12
The blank is type of decision-maker who over analyzes information
Answers: 3
image
Computers and Technology, 22.06.2019 03:00, TamB01
How can i clip a picture to a question on the computer?
Answers: 1
image
Computers and Technology, 22.06.2019 04:30, ParallelUniverse
Which of the statements below is true? the formatting, standard, and drawing commands are unavailable. the formatting, standard, and drawing commands have been used. the formatting, standard, and drawing toolbars are displayed. the formatting, standard, and drawing toolbars are hidden.
Answers: 1
Do you know the correct answer?
Consider a relation BOOKS that holds information about the inventory of books (used or new) in a boo...

Questions in other subjects:

Konu
Arts, 05.10.2020 14:01
Konu
Social Studies, 05.10.2020 14:01
Konu
Mathematics, 05.10.2020 14:01
Konu
Mathematics, 05.10.2020 14:01