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, 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)
• 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)
1 answer:
Answer:
See explaination
Explanation:
Somehing is considered functional dependent (FD) if a relationship between two attributes, typically between the PK and other non-key attributes within a table. For any relation R, attribute Y is functionally dependent on attribute X (usually the PK), if for every valid instance of X, that value of X uniquely determines the value of Y.
Please kindly check attachment for the other details.
You might be interested in
Answer:
The following are the program to the given question:
import java.util.*;//import package for user input
public class Make //define class Make
{
public static void main(String[] ask) //define a main method
{
Scanner obx = new Scanner(System.in); //declare the Scanner class object
int size=obx.nextInt(); //get the size of the array from the user
int a[]=new int[size]; //declare an integer array with given size
String word[]=new String[size]; //declare a string array with given size
for(int i=0;i<size;i++) //set the for loop
word[i]=obx.next(); //get string input from the user
for(int i=0;i<size;i++) //iterates with the array, increase the count
{
for(int j=0;j<size;j++) //defining a loop to check value
{
if(word[i].equals(word[j])) //use if to check that elements of words
a[i]++;//increamenting array size
}
}
System.out.print("\n"); //use print for break line
for(int i=0;i<size;i++)//set for loop to print the following result
System.out.println(word[i]+" "+a[i]);//print value
}
}
Output:
Please find the attachment file.
Explanation:
- First, establish the predefined package required and instead define the main class and define the main method within the class and method.
- Declare the scanner class object and receive an object size in the 'size' variable thru the array.
- Next create two arrays, the integer type "a" with both the input size given and the string type "word" with the input size supplied.
- Define the loop for which string array elements are acquired and set two to again for loop, which increases with loop iteration the integer data type array by one.
- Lastly, set the loop for which this result is printed.
