Computers and Technology, 15.04.2020 01:06, rosemary909
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.)
Answers: 1
Computers and Technology, 21.06.2019 18:00, kayleeemerson77
Ihave buncha points. does anyone want any?
Answers: 1
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
Consider a relation BOOKS that holds information about the inventory of books (used or new) in a boo...
Arts, 05.10.2020 14:01
Biology, 05.10.2020 14:01
Chemistry, 05.10.2020 14:01
Social Studies, 05.10.2020 14:01
Mathematics, 05.10.2020 14:01
Mathematics, 05.10.2020 14:01
Chemistry, 05.10.2020 14:01