subject

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

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 17:00
The two main ways in which marketers address the competition with their strategies are by satisfying a need better than a competition and by
Answers: 2
question
Computers and Technology, 22.06.2019 19:20
Write a program that prompts the user to input a string. the program then uses the function substr to remove all the vowels from the string. for example, if str = "there", then after removing all the vowels, str = "thr". after removing all the vowels, output the string. your program must contain a function to remove all the vowels and a function to determine whether a character is a vowel.
Answers: 2
question
Computers and Technology, 23.06.2019 15:30
1. ask the user how many questions are in the quiz. 2. ask the user to enter the key (that is, the correct answers). there should be one answer for each question in the quiz, and each answer should be an integer. e.g., 34 7 13 100 81 3 9 10 321 12 might be the key for a 10-question quiz. you will need to store the key in an array. 3. ask the user to enter the answers for the quiz to be graded. there needs to be one answer for each question. note that these answers do not need to be stored; each answer can simply be compared to the key as it is entered. 4. when the user has entered all of the answers to be graded, print the number correct and the percent correct. 5. add a loop so that the user can grade any number of quizzes with a single key. after the results have been printed for each quiz, ask "grade another quiz? (y/n)." note: you only have one array (the key). you are not creating a new key for each set of quiz answers.
Answers: 3
question
Computers and Technology, 23.06.2019 23:00
How do you know if the website is secure if you make a purchase
Answers: 2
You know the right answer?
Consider a relation BOOKS that holds information about the inventory of books (used or new) in a boo...
Questions
question
Mathematics, 03.02.2021 01:00
question
Geography, 03.02.2021 01:00
question
Computers and Technology, 03.02.2021 01:00
question
Biology, 03.02.2021 01:00
question
Mathematics, 03.02.2021 01:00
question
Mathematics, 03.02.2021 01:00
Questions on the website: 13722363